Postgres Pro
Downloads
Home   >   mailing lists

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

From Kris Jurka
Subject Re: MINUS & ROWNUM in PostGres
Date
Msg-id Pine.LNX.4.33.0309080420110.4807-100000@leary.csoft.net
Whole thread Raw
In response to Re: MINUS & ROWNUM in PostGres  (Rod Taylor <rbt@rbt.ca>)
List pgsql-sql
Tree view 

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

pgsql-sql by date:

Previous
From: "Jainendra Kumar P"
Date:
Subject: How can I optimize this query
Next
From: Jomon Skariah
Date:
Subject: Re: MINUS & ROWNUM in PostGres