Re: MINUS & ROWNUM in PostGres

From: Rod Taylor <rbt(at)rbt(dot)ca>
To: Jomon Skariah <jomons(at)aztec(dot)soft(dot)net>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: MINUS & ROWNUM in PostGres
Date: 2003-09-04 19:50:28
Message-ID: 1062705027.88158.23.camel@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> 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.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tomasz Myrta 2003-09-04 19:56:24 Re: running aggregates
Previous Message scott.marlowe 2003-09-04 15:16:01 Re: Fw: Change column data type