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