Received: from sd.tpf.co.jp (sd.tpf.co.jp [210.161.239.34]) by hub.org (8.10.1/8.10.1) with ESMTP id e584jlb73318; Thu, 8 Jun 2000 00:45:47 -0400 (EDT) Received: from cadzone ([126.0.1.40] (may be forged)) by sd.tpf.co.jp (2.5 Build 2640 (Berkeley 8.8.6)/8.8.4) with SMTP id NAA01166; Thu, 08 Jun 2000 13:45:32 +0900 From: "Hiroshi Inoue" To: "Ed Loehr" , "mikeo" Cc: , Subject: RE: Re: [SQL] oracle rownum equivalent? Date: Thu, 8 Jun 2000 13:47:34 +0900 Message-ID: <000e01bfd104$a9ae25a0$2801007e@tpf.co.jp> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook 8.5, Build 4.71.2173.0 In-Reply-To: <393E6C2A.825BF2B7@austin.rr.com> X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 Importance: Normal X-Archive-Number: 200006/227 > -----Original Message----- > From: pgsql-general-owner@hub.org [mailto:pgsql-general-owner@hub.org]On > Behalf Of Ed Loehr > > mikeo wrote: > > > > thanks for the response. oid is equivalent to oracle rowid. IMHO,tid is equivalent to Oracle's 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. > > I think this might be the list, but you might query pgsql-hackers for > more info. There was a recent thread involving this.. > > ctid > oid > xmin (minimum transaction number) > xmax > cmin (minimum command number) > cmax > > ctid may be what you're looking for, but I don't understand very well how > these are used. Maybe someone else can say or you can experiment... > AFAIK,there's no pseudo-column like Oracle's rownum which is dynamically allocated at execution time. Regards. Hiroshi Inoue Inoue@tpf.co.jp