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.