Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.1) with SMTP id f4BDR7A65275 for ; Fri, 11 May 2001 09:27:07 -0400 (EDT) (envelope-from pgsql-sql-owner@postgresql.org) Received: from callserve.com (mail.callserve.com [62.189.6.56]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f48G1qA33075 for ; Tue, 8 May 2001 12:01:53 -0400 (EDT) (envelope-from Robert.Beer@callserve.com) Received: from csoff2exc01.callserve.com (unverified) by callserve.com (Content Technologies SMTPRS 4.2.1) with ESMTP id for ; Tue, 8 May 2001 17:01:36 +0100 Received: by csoff2exc01.callserve.com with Internet Mail Service (5.5.2650.21) id ; Tue, 8 May 2001 16:01:36 -0000 Message-ID: From: Robert Beer To: "'pgsql-sql@postgresql.org'" Subject: Newbie ex-Oracle person's question: Oracle ROWID = PSQL OID, Orac le ROWNUM = PSQL ??? Date: Tue, 8 May 2001 16:01:33 -0000 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2650.21) Content-Type: text/plain; charset="iso-8859-1" X-Archive-Number: 200105/94 X-Sequence-Number: 2895 Oracle has a ROWNUM pseudo column that works like this ... TEST>select callid, rownum from cs_calls where rownum < 5; CALLID ROWNUM ---------- ---------- 7806 1 7807 2 7809 3 6443 4 4 rows selected. ... which can be quite handy. Is there something like this in PSQL? By the way, having used Oracle since 1987 it's a pleasure to use PSQL. Someone actually thinks about the implemented features. For example, Oracle's implementation of ROWNUM gives them in the order the rows were BEFORE the ORDER BY, which is not of much use as adding an ORDER BY jumbles them up. Duh! Thanks in advance for any responses.