Re: MINUS & ROWNUM in PostGres

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(at)ejurka(dot)com]
Sent: Monday, September 08, 2003 1:52 PM
To: Rod Taylor
Cc: Jomon Skariah; pgsql-sql(at)postgresql(dot)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