Re: [SQL] MINUS & ROWNUM in PostGres

Hi, Thanx for your reply. The problem is we are using PostGres 7.1.In this version REPLACE() is not available. Regards Jomon -Original Message- From: Rod Taylor [mailto:[EMAIL PROTECTED] Sent: Monday, September 08, 2003 7:41 PM To: Jomon Skariah Cc: Kris Jurka; [EMAIL

Re: [SQL] MINUS & ROWNUM in PostGres

Hi, Do we have any replacement for REPLACE() of Oracle in PostGres? I know we can function to do same job. Regards Jomon -Original Message- From: Kris Jurka [mailto:[EMAIL PROTECTED] Sent: Monday, September 08, 2003 1:52 PM To: Rod Taylor Cc: Jomon Skariah; [EMAIL PROTECTED

[SQL] Porting from Oracl to Postgres

Hi, Thanks for your replys. We are facing another problem now. we need to find an alternative for Oracle's ADD_MONTHS in PostGres.. Regards Jomon -Original Message- From: Rod Taylor [mailto:[EMAIL PROTECTED] Sent: Friday, September 05, 2003 1:20 AM To: Jomon Skari

[SQL] MINUS & ROWNUM in PostGres

Hi, We are in the process of migrating of our application from Oracle to PostGreSQL. we are facing a few problems with PL/SQL Code.. 1) Do we have a replacement in PostGres for MINUS operator of Oracle . 2 Also I need to find an alternative for ROWNUM in oracle.. Can anyo

[SQL] Porting from PL/SQL to PLPGSQL

Hi All, We are in the process of migrating of our application from Oracle to PostGreSQL. we are facing a few problems with PL/SQL Code.. 1) In Oracle sqlplus we can run sql script files as @script_name; How do we do the same in PostGres. Also is there any replacement for

Re: [SQL] Porting from PL/SQL to PLPGSQL

Hi Josh, Thanks for your reply. In our PL/SQL code we have used userenv('LANG') in some of the INSERT statements. Do we have a replacement for this.. Regards Jomon -Original Message- From: Josh Berkus [mailto:[EMAIL PROTECTED] Sent: Thursday, August 14, 2003 1:05 AM

[SQL] Porting from PL/SQL to PLPGSQL

CATALOG > IDENTIFIED BY &ORA_PASSWORD > DEFAULT TABLESPACE &DFLT_TABLESPACE > TEMPORARY TABLESPACE &TEMP_TABLESPACE > > > Regards > > Jomon Skariah. > ---(end of broadcast)---

[SQL] Porting from PL/SQL to PLPGSQL

2 Oracle have a function USERENV to get the user session information.Is there any replacement available in PostGres. ? 3 Is there any replace available for INSTEAD OF INSERT/DELETE/UPDATE for triggers in PostGreSQL. Regards Jomon Skariah. ---(end of broa