Received: from jupiter.hub.org (jupiter.hub.org [64.49.215.5]) by postgresql.org (Postfix) with ESMTP id 1ACD4474E71 for ; Sat, 9 Mar 2002 19:05:12 -0500 (EST) Received: (from news@localhost) by jupiter.hub.org (8.11.6/8.11.6) id g29Nmbp90304 for pgsql-sql@postgresql.org; Sat, 9 Mar 2002 17:48:37 -0600 (CST) (envelope-from news) From: Hubert Palme X-Newsgroups: comp.databases.postgresql.sql Subject: Line Numbering in SELRCT Output Date: Sun, 10 Mar 2002 00:48:38 +0100 Organization: None Lines: 16 Message-ID: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7Bit X-Complaints-To: news@hub.org User-Agent: KNode/0.4 To: pgsql-sql@postgresql.org X-Archive-Number: 200203/169 X-Sequence-Number: 7049 Hi, how can I get line numbers in the output of a select statement, e.g. No. | Name | ... -----+------------------+------- 1 | Meyer | ... 2 | Miller | ... 3 | Mueller | ... 4 | Smith | ... Thanks in advance, -- Hubert Palme Am Walde 1 42119 Wuppertal