Skip site navigation (1) Skip section navigation (2)

Re: Number the lines

From: Haller Christoph <ch(at)rodos(dot)fzk(dot)de>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Number the lines
Date: 2001-09-17 14:15:32
Message-ID: 200109171215.OAA21602@rodos (view raw, whole thread or download thread mbox)
Lists: pgsql-sql
Am I right in assuming you were asking for 
something like 
SELECT Rownumbering(), ... FROM <Table> ORDER BY <Column> ; 
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 


pgsql-sql by date

Next:From: Stephan SzaboDate: 2001-09-17 14:57:54
Subject: Re: Checking for table existence
Previous:From: Kovacs BaldvinDate: 2001-09-17 12:54:51
Subject: Re: Number the lines

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group