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
CATALOG
> IDENTIFIED BY &ORA_PASSWORD
> DEFAULT TABLESPACE &DFLT_TABLESPACE
> TEMPORARY TABLESPACE &TEMP_TABLESPACE
>
>
> Regards
>
> Jomon Skariah.
>
---(end of broadcast)---
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
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
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
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
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
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
