Re: Number the lines - Mailing list pgsql-sql

From Kovacs Baldvin
Subject Re: Number the lines
Date
Msg-id Pine.GSO.4.33.0109171446130.8732-100000@ural2
Whole thread Raw
In response to Re: Number the lines  (Haller Christoph <ch@rodos.fzk.de>)
Responses Re: Number the lines
List pgsql-sql
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...

Bye,
Baldvin




pgsql-sql by date:

Previous
From: joe.celko@trilogy.com (--CELKO--)
Date:
Subject: Re: group by weirdness
Next
From: degoble@sgtech (David. E. Goble)
Date:
Subject: I could do with some guidance