Received: from gw.spectrumtelecorp.com (216-064-054-021.inaddr.vitts.com [216.64.54.21]) by hub.org (8.10.1/8.10.1) with ESMTP id e58CAtb54597 for ; Thu, 8 Jun 2000 08:10:55 -0400 (EDT) Received: from spec34 (spec34.spectrumtelecorp.com [192.168.1.67]) by gw.spectrumtelecorp.com (8.9.3/8.8.7) with SMTP id IAA21847; Thu, 8 Jun 2000 08:15:09 -0400 Message-Id: <3.0.1.32.20000608082010.0092bdb0@pop.spectrumtelecorp.com> X-Sender: mikeo@pop.spectrumtelecorp.com X-Mailer: Windows Eudora Pro Version 3.0.1 (32) Date: Thu, 08 Jun 2000 08:20:10 -0400 To: "Cary O'Brien" , pgsql-general@hub.org From: mikeo Subject: Re: Re: [SQL] oracle rownum equivalent? In-Reply-To: <200006072247.SAA03722@saltmine.radix.net> References: <3.0.1.32.20000607101423.00930360@pop.spectrumtelecorp.com> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" X-Archive-Number: 200006/232 At 06:47 PM 6/7/00 -0400, Cary O'Brien wrote: > >> 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 > i'll have to respectfully disagree with you on your interpretation of rownum. in oracle, rownum tells only the relative position of a row in a result set. also, it is an integer value starting at 1 up to nrows retrieved and is used, for the most part, to limit the result set and not for fast lookups. it also can be used in a DML statement within a function, such as mod(), to aid in generating a value. the point here is moot though, as postgres doesn't have an equivalent and i'll have to learn to live without that small piece of oracle and enjoy what i see as the greater benefits of postgres. :) mikeo