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 03CF452816 for ; Tue, 17 May 2005 14:08:03 -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 34783-07 for ; Tue, 17 May 2005 17:07:54 +0000 (GMT) Received: from wolff.to (wolff.to [66.93.197.194]) by svr1.postgresql.org (Postfix) with SMTP id A016452835 for ; Tue, 17 May 2005 14:07:52 -0300 (ADT) Received: (qmail 22789 invoked by uid 500); 17 May 2005 17:06:16 -0000 Date: Tue, 17 May 2005 12:06:16 -0500 From: Bruno Wolff III To: Dennis.Jiang@thomson.com Cc: pgsql-sql@postgresql.org Subject: Re: Does Postgresql have a similar pseudo-column "ROWNUM" as Oracle? Message-ID: <20050517170616.GA20919@wolff.to> Mail-Followup-To: Bruno Wolff III , Dennis.Jiang@thomson.com, pgsql-sql@postgresql.org References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.009 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200505/129 X-Sequence-Number: 21442 On Thu, May 12, 2005 at 13:07:00 -0600, Dennis.Jiang@thomson.com wrote: > 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: No. > > select * > from (select RowNum, pg_catalog.pg_proc.* > from pg_catalog.pg_proc) inline_view > where RowNum between 100 and 200; You could use LIMIT and OFFSET to get the values from the table for the 100th through 200th rows (though typically you want to add an ORDER BY clause). You could have you application supply the rownum column values.