Postgres Pro
Downloads
Home   >   mailing lists

Re: MINUS & ROWNUM in PostGres - Mailing list pgsql-sql

From Rod Taylor
Subject Re: MINUS & ROWNUM in PostGres
Date
Msg-id 1062705027.88158.23.camel@jester
Whole thread Raw
In response to MINUS & ROWNUM in PostGres  (Jomon Skariah <jomons@aztec.soft.net>)
Responses Re: MINUS & ROWNUM in PostGres  (Kris Jurka <books@ejurka.com>)
List pgsql-sql
Tree view 
> 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.

pgsql-sql by date:

Previous
From: Jomon Skariah
Date:
Subject: MINUS & ROWNUM in PostGres
Next
From: Tomasz Myrta
Date:
Subject: Re: running aggregates