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 439A0D1B513 for ; Mon, 8 Sep 2003 08:21:31 +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 83487-10 for ; Mon, 8 Sep 2003 05:21:02 -0300 (ADT) Received: from mail63.csoft.net (leary.csoft.net [63.111.22.80]) by svr1.postgresql.org (Postfix) with SMTP id E37DCD1B4E2 for ; Mon, 8 Sep 2003 05:20:58 -0300 (ADT) Received: (qmail 11739 invoked by uid 1112); 8 Sep 2003 08:21:44 -0000 Date: Mon, 8 Sep 2003 04:21:44 -0400 (EDT) From: Kris Jurka X-X-Sender: To: Rod Taylor Cc: Jomon Skariah , Subject: Re: MINUS & ROWNUM in PostGres In-Reply-To: <1062705027.88158.23.camel@jester> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/71 X-Sequence-Number: 15049 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