X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.130])
	by svr1.postgresql.org (Postfix) with ESMTP id 71071D1B52B
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon,  8 Sep 2003 13:47:29 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new,
	port 10024) with ESMTP id 46860-05
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon,  8 Sep 2003 10:47:02 -0300 (ADT)
Received: from param.aztec.soft.net (param.aztec.soft.net [164.164.151.8])
	by svr1.postgresql.org (Postfix) with ESMTP id 7BE69D1B53A
	for <pgsql-sql@postgresql.org>; Mon,  8 Sep 2003 10:46:55 -0300 (ADT)
Received: from maya.aztec.soft.net (maya.aztec.soft.net [164.164.151.5])
	by param.aztec.soft.net (8.11.2/8.11.2) with ESMTP id h88EXYp22347;
	Mon, 8 Sep 2003 20:03:36 +0530
Received: by maya.aztec.soft.net with Internet Mail Service (5.5.2653.19)
	id <SP9CKCN2>; Mon, 8 Sep 2003 19:14:59 +0530
Message-ID: <F83B457BE363174B8233DE042A1445705F6DA2@maya.aztec.soft.net>
From: Jomon Skariah <jomons@aztec.soft.net>
To: Kris Jurka <books@ejurka.com>, Rod Taylor <rbt@rbt.ca>
Cc: pgsql-sql@postgresql.org
Subject: Re: MINUS & ROWNUM in PostGres
Date: Mon, 8 Sep 2003 19:14:58 +0530 
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.5.2653.19)
Content-Type: text/plain;
	charset="iso-8859-1"
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200309/73
X-Sequence-Number: 15051



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