From: | Jomon Skariah <jomons(at)aztec(dot)soft(dot)net> |
---|---|
To: | Kris Jurka <books(at)ejurka(dot)com>, Rod Taylor <rbt(at)rbt(dot)ca> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: MINUS & ROWNUM in PostGres |
Date: | 2003-09-08 13:44:58 |
Message-ID: | F83B457BE363174B8233DE042A1445705F6DA2@maya.aztec.soft.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(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
From | Date | Subject | |
---|---|---|---|
Next Message | Rod Taylor | 2003-09-08 14:11:24 | Re: MINUS & ROWNUM in PostGres |
Previous Message | George Weaver | 2003-09-08 12:41:30 | Re: [SQL] [GENERAL] plPGSQL bug in function creation |