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:rbt(at)rbt(dot)ca]
Sent: Friday, September 05, 2003 1:20 AM
To: Jomon Skariah
Cc: pgsql-sql(at)postgresql(dot)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.