Re: MINUS & ROWNUM in PostGres

From: Kris Jurka <books(at)ejurka(dot)com>
To: Rod Taylor <rbt(at)rbt(dot)ca>
Cc: Jomon Skariah <jomons(at)aztec(dot)soft(dot)net>, <pgsql-sql(at)postgresql(dot)org>
Subject: Re: MINUS & ROWNUM in PostGres
Date: 2003-09-08 08:21:44
Message-ID: Pine.LNX.4.33.0309080420110.4807-100000@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Thu, 4 Sep 2003, Rod Taylor wrote:

> > 2 Also I need to find an alternative for ROWNUM in oracle..
>
> If you are looking for a unique identifier, try using the OID.
>

ROWID is oracle's unique identifier, ROWNUM is the row number in a query
result. In the past it has been suggested that ROWNUM could be replaced
by the nextval of a temporary sequence.

Kris Jurka

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Marek Lewczuk 2003-09-08 08:32:28 plPGSQL bug in function creation
Previous Message Tom Lane 2003-09-07 14:22:33 Re: SQL subqueries newbie help