On 17 Sep 2001 14:54:51 +0200, Kovacs Baldvin wrote:
Hi!
I am in the university now, not be able to test what I
say, so please forgive me if it is buggy or wrong.
So does it helps you?:
That works correctly. Thanks very much for the tip
.
Do not forget to DROP the sequence afterwards,
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
Hi!
I am in the university now, not be able to test what I
say, so please forgive me if it is buggy or wrong.
So does it helps you?:
CREATE SEQUENCE ordering;
SELECT NEXTVAL('ordering') as rownumber, *
INTO TABLE anewname FROM whatyouwant;
Probably CREATE SEQUENCE 'ordering';, do try it...