Received: from jupiter.hub.org (jupiter.hub.org [64.49.215.5]) by postgresql.org (Postfix) with ESMTP id 428DA475469 for ; Sun, 10 Mar 2002 10:35:19 -0500 (EST) Received: (from news@localhost) by jupiter.hub.org (8.11.6/8.11.6) id g2AFWDd95413 for pgsql-sql@postgresql.org; Sun, 10 Mar 2002 09:32:13 -0600 (CST) (envelope-from news) From: "Paul" X-Newsgroups: comp.databases.postgresql.sql Subject: Re: Line Numbering in SELRCT Output Date: Sun, 10 Mar 2002 20:33:01 +0500 Organization: Hub.Org Networking Services (http://www.hub.org) Lines: 26 Message-ID: References: X-Complaints-To: news@hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4522.1200 x-mimeole: Produced By Microsoft MimeOLE V5.50.4522.1200 To: pgsql-sql@postgresql.org X-Archive-Number: 200203/157 X-Sequence-Number: 7037 CREATE SEQUENCE seq1; SELECT nextval('seq1'), amname FROM pg_am; DROP SEQUENCE seq1; "Hubert Palme" wrote in message news:a6e70l$2o5p$1@jupiter.hub.org... > 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 >