Received: from ncc1701.cistron.net (ncc1701.cistron.net [195.64.68.38]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f4BFTjA28435 for ; Fri, 11 May 2001 11:29:45 -0400 (EDT) (envelope-from news@uucp.cistron.nl) Received: from news by ncc1701.cistron.net with local (Exim 3.20 #1 (Debian)) id 14yErL-0007ce-00 for ; Fri, 11 May 2001 17:29:39 +0200 From: jdassen@cistron.nl (J.H.M. Dassen (Ray)) Subject: Re: Newbie ex-Oracle person's question: Oracle ROWID = PSQL OID, Orac le ROWNUM = PSQL ??? Date: Fri, 11 May 2001 15:29:39 +0000 (UTC) Organization: Cistron Internet Services B.V. Lines: 13 Message-ID: References: X-Trace: ncc1701.cistron.net 989594979 26888 195.64.65.236 (11 May 2001 15:29:39 GMT) X-Complaints-To: abuse@cistron.nl To: pgsql-sql@postgresql.org Errors-To: <> X-Archive-Number: 200105/96 X-Sequence-Number: 2908 Robert Beer wrote: > Oracle has a ROWNUM pseudo column that works like this ... > TEST>select callid, rownum from cs_calls where rownum < 5; > Is there something like this in PSQL? SELECT callid FROM cs_calls LIMIT 4; HTH, Ray -- Give a man a fire, he's warm for a day. Set a man on fire, he's warm for the rest of his life.