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 A37BBD1BAD8 for ; Thu, 4 Sep 2003 19:50:38 +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 76455-05 for ; Thu, 4 Sep 2003 16:50:09 -0300 (ADT) Received: from mailav.tor1.inquent.com (mail.inquent.com [216.208.117.106]) by svr1.postgresql.org (Postfix) with ESMTP id 9DB1DD1B56C for ; Thu, 4 Sep 2003 16:50:07 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by mailav.tor1.inquent.com (Postfix) with ESMTP id 6D9841025C; Thu, 4 Sep 2003 15:42:02 -0400 (EDT) Received: from [10.0.2.5] (unknown [10.0.2.5]) by mailav.tor1.inquent.com (Postfix) with ESMTP id 758AB10248; Thu, 4 Sep 2003 15:42:00 -0400 (EDT) Subject: Re: MINUS & ROWNUM in PostGres From: Rod Taylor To: Jomon Skariah Cc: pgsql-sql@postgresql.org In-Reply-To: References: Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-sOvoprJ+74qtaSS7HFU9" Message-Id: <1062705027.88158.23.camel@jester> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.4 Date: Thu, 04 Sep 2003 15:50:28 -0400 X-Virus-Scanned: by AMaViS perl-11 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/20 X-Sequence-Number: 14998 --=-sOvoprJ+74qtaSS7HFU9 Content-Type: text/plain Content-Transfer-Encoding: quoted-printable > 1) Do we have a replacement in PostGres for MINUS operator of Oracle . I believe MINUS is non-standard word for EXCEPT, correct? =09 > 2 Also I need to find an alternative for ROWNUM in oracle.. If you are looking for a unique identifier, try using the OID. --=-sOvoprJ+74qtaSS7HFU9 Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.3 (FreeBSD) iD8DBQA/V5eD6DETLow6vwwRAiB4AJ49By1xeaZLfSOPXUgcjP51eISYvwCfWC5Y Zbzhji22RIQ06oXx2YJ58BM= =06vl -----END PGP SIGNATURE----- --=-sOvoprJ+74qtaSS7HFU9--