Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f8ECJi732013 for ; Fri, 14 Sep 2001 08:19:44 -0400 (EDT) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.4/8.11.4) id f8EC5qn45535 for pgsql-sql@postgresql.org; Fri, 14 Sep 2001 08:05:52 -0400 (EDT) (envelope-from news) From: yaubi@yaubi.com (Yoann) X-Newsgroups: comp.databases.postgresql.sql Subject: Number the lines Date: 14 Sep 2001 05:05:49 -0700 Organization: http://groups.google.com/ Lines: 8 Message-ID: <70c8063b.0109140405.1895bf0d@posting.google.com> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Complaints-To: groups-abuse@google.com To: pgsql-sql@postgresql.org X-Archive-Number: 200109/78 X-Sequence-Number: 4724 how can I number the result's lines of a sql query ? explaination : I have a query which return me a list of values. I need to order them (it's ok, easy ;) and then number the lines. The goal is then to extract, for example, "the third maximum value". Tx in advance ! Yoann