Porting from Oracl to Postgres - Mailing list pgsql-sql

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:rbt@rbt.ca]
Sent: Friday, September 05, 2003 1:20 AM
To: Jomon Skariah
Cc: pgsql-sql@postgresql.org
Subject: Re: MINUS & ROWNUM in PostGres


> 1)     Do we have a replacement in PostGres for MINUS operator of Oracle .

I believe MINUS is non-standard word for EXCEPT, correct?
> 2    Also I need to find an alternative for ROWNUM in oracle..

If you are looking for a unique identifier, try using the OID.