Received: from mail1.radix.net (mail1.radix.net [207.192.128.31]) by hub.org (8.10.1/8.10.1) with ESMTP id e57Mlhc30432 for ; Wed, 7 Jun 2000 18:47:43 -0400 (EDT) Received: from saltmine.radix.net (saltmine.radix.net [207.192.128.40]) by mail1.radix.net (8.9.3/8.9.3) with ESMTP id SAA14005 for ; Wed, 7 Jun 2000 18:47:42 -0400 (EDT) Received: (from cobrien@localhost) by saltmine.radix.net (8.8.7/8.8.7) id SAA03722 for pgsql-general@hub.org; Wed, 7 Jun 2000 18:47:39 -0400 (EDT) From: "Cary O'Brien" Message-Id: <200006072247.SAA03722@saltmine.radix.net> Subject: Re: Re: [SQL] oracle rownum equivalent? In-Reply-To: <3.0.1.32.20000607101423.00930360@pop.spectrumtelecorp.com> from mikeo at "Jun 7, 2000 10:14:23 am" To: pgsql-general@hub.org Date: Wed, 7 Jun 2000 18:47:39 -0400 (EDT) X-Mailer: ELM [version 2.4ME+ PL48 (25)] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Archive-Number: 200006/221 > thanks for the response. oid is equivalent to oracle rowid. I think there is a fundamentel difference between oid and rownum. Oid is just a serial number. Rownum is a long string that tells oracle where exactly the row is. So *I think* rownum can be used for fast lookups, where oid, unless indexed, can't. Other than that they are the same pretty much. -- cary