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, otherwise you will find the line numbers continuing the sequence in the next SELECT statement. > CREATE SEQUENCE ordering; > SELECT NEXTVAL('ordering') as rownumber, * > INTO TABLE anewname FROM whatyouwant; > > Probably CREATE SEQUENCE 'ordering';, do try it... No, you do not need the quote characters. Sincerely etc.. C. ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org