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

Hi,

Do we have any replacement for REPLACE() of Oracle in PostGres?

I know we can function to do same job.


Regards

Jomon



-----Original Message-----
From: Kris Jurka [mailto:books@ejurka.com]
Sent: Monday, September 08, 2003 1:52 PM
To: Rod Taylor
Cc: Jomon Skariah; pgsql-sql@postgresql.org
Subject: Re: [SQL] MINUS & ROWNUM in PostGres




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