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 e57E53W55829; Wed, 7 Jun 2000 10:05:03 -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 KAA12639; Wed, 7 Jun 2000 10:09:20 -0400 Message-Id: <3.0.1.32.20000607101423.00930360@pop.spectrumtelecorp.com> X-Sender: mikeo@pop.spectrumtelecorp.com X-Mailer: Windows Eudora Pro Version 3.0.1 (32) Date: Wed, 07 Jun 2000 10:14:23 -0400 To: Ed Loehr From: mikeo Subject: Re: [SQL] oracle rownum equivalent? Cc: pgsql-general@postgresql.org, pgsql-sql@postgresql.org In-Reply-To: <393E4E29.649C3C5@austin.rr.com> References: <3.0.1.32.20000607082428.00925870@pop.spectrumtelecorp.com> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" X-Archive-Number: 200006/192 thanks for the response. oid is equivalent to oracle rowid. rownum can be used similar to the limit option of select in postgres but in oracle it can also be used in a where clause, or as an assigment in an update statement for instance. eg: update ctmaster set bsc_id = mod(rownum,3) +1; this gives me a way to assign streams to rows in a load balanced manner on the fly, for example. i use it in other more involved ways than this also. i cannot do this with limit. i could do this with sequence with a max value but i'd have to define a sequence each time i wanted to do something "on the fly" or for what ifs. what i'm also interested in is how to find reference to these type of pseudo-columns, even just the names of them, if they're listed somewhere. thanks again, mikeo At 08:29 AM 6/7/00 -0500, Ed Loehr wrote: >mikeo wrote: >> >> is there an equivalent to rownum in oracle? >> >> also, where can one find reference to "hidden columns" >> such as OID or, as in oracle, rownum? > >oid is the equivalent. not sure documentation exists for these... > >Regards, >Ed Loehr >