X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 7C1F553E47 for ; Thu, 12 May 2005 16:08:05 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 94130-03 for ; Thu, 12 May 2005 19:07:55 +0000 (GMT) Received: from mailout-tlr.thomson.com (mailout-tlr.thomson.com [163.231.12.68]) by svr1.postgresql.org (Postfix) with ESMTP id 3443A53763 for ; Thu, 12 May 2005 16:07:52 -0300 (ADT) Received: from mailout-tlr.thomson.com (localhost [127.0.0.1]) by mailout-tlr.thomson.com (Switch-3.1.4/Switch-3.1.0) with ESMTP id j4CJ7oKZ029645 for ; Thu, 12 May 2005 19:07:50 GMT Received: from tlrusmneagfe01.ERF.THOMSON.COM (tlrusmneagfe01.erf.thomson.com [163.231.22.161]) by mailout-tlr.thomson.com (Switch-3.1.4/Switch-3.1.0) with ESMTP id j4CJ4SVq027254 for ; Thu, 12 May 2005 19:07:49 GMT Received: from tshusnjmonbh02.ERF.THOMSON.COM ([170.107.24.66]) by tlrusmneagfe01.ERF.THOMSON.COM with Microsoft SMTPSVC(6.0.3790.211); Thu, 12 May 2005 14:07:43 -0500 Received: from tshuscodenfe01.ERF.THOMSON.COM ([10.232.179.63]) by tshusnjmonbh02.ERF.THOMSON.COM with Microsoft SMTPSVC(6.0.3790.211); Thu, 12 May 2005 15:07:40 -0400 Received: from tshuscodenmbx01.ERF.THOMSON.COM ([10.232.179.61]) by tshuscodenfe01.ERF.THOMSON.COM with Microsoft SMTPSVC(6.0.3790.211); Thu, 12 May 2005 13:07:00 -0600 X-MimeOLE: Produced By Microsoft Exchange V6.5.6944.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Subject: Does Postgresql have a similar pseudo-column "ROWNUM" as Oracle? Date: Thu, 12 May 2005 13:07:00 -0600 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Does Postgresql have a similar pseudo-column "ROWNUM" as Oracle? Thread-Index: AcVXJcOKR1dMpUVBQTyut64YKJzJkg== From: To: Cc: X-OriginalArrivalTime: 12 May 2005 19:07:00.0873 (UTC) FILETIME=[C6AF9790:01C55725] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.178 tagged_above=0 required=5 tests=NO_REAL_NAME X-Spam-Level: X-Archive-Number: 200505/124 X-Sequence-Number: 21437 Hi: Oracle has a pseudo-column "ROWNUM" to return the sequence number in = which a row was returned when selected from a table. The first row = ROWNUM is 1, the second is 2, and so on. Does Postgresql have a similar pseudo-column "ROWNUM" as Oracle? If so, = we can write the following query: select *=20 from (select RowNum, pg_catalog.pg_proc.*=20 from pg_catalog.pg_proc) inline_view where RowNum between 100 and 200; Thanks, Dennis