| From: | Christopher Sawtell <csawtell(at)paradise(dot)net(dot)nz> |
|---|---|
| To: | Kovacs Baldvin <kb136(at)hszk(dot)bme(dot)hu> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Number the lines |
| Date: | 2001-09-18 22:54:26 |
| Message-ID: | 20010918225449.C87FF1F9EEB@deborah.paradise.net.nz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Philip Hallstrom | 2001-09-18 23:21:34 | Re: Holiday Calculations? |
| Previous Message | Denis Bucher | 2001-09-18 19:55:37 | Re: URGENT ! Nouveau virus |