Received: from resy5.fzk.de (resy5.fzk.de [141.52.68.8]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f8HCFq865728 for ; Mon, 17 Sep 2001 08:15:53 -0400 (EDT) (envelope-from ch@rodos.fzk.de) Received: by rodos.fzk.de with ESMTP (8.8.6 (PHNE_17135)/8.7.1) id OAA22585 for ; Mon, 17 Sep 2001 14:16:13 +0200 (METDST) From: Haller Christoph Message-Id: <200109171215.OAA21602@rodos> Subject: Re: Number the lines To: pgsql-sql@postgresql.org Date: Mon, 17 Sep 2001 14:15:32 METDST X-Mailer: Elm [revision: 212.4] X-Archive-Number: 200109/102 X-Sequence-Number: 4766 Am I right in assuming you were asking for something like SELECT Rownumbering(), ... FROM ORDER BY ; and expecting a result like 1| ... 2| ... 3| ... ... where Rownumbering() is a PostgreSQL function If this is what you wanted, this is something I want for a long time too. Maybe we should stick together and tell the PostgreSQL hackers about our wish. Or maybe something like this already exists, but we haven't noticed yet. Regards, Christoph