From: | "Davis, Sean \(NIH/NCI\) [E]" <sdavis2(at)mail(dot)nih(dot)gov> |
---|---|
To: | <operationsengineer1(at)yahoo(dot)com>, <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Insert Question |
Date: | 2006-11-02 20:16:04 |
Message-ID: | 014DBF86B19310419F0DF8910FC56457240CF8@nihcesmlbx10.nih.gov |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
I would look at creating a temp table as:
select product_number,generate_series(4200001,4200001+(select count(*) from product_number)) order by product_number;
Then rename the temp table back to the original table.
Sean
-----Original Message-----
From: operationsengineer1(at)yahoo(dot)com [mailto:operationsengineer1(at)yahoo(dot)com]
Sent: Thu 11/2/2006 3:01 PM
To: pgsql-novice(at)postgresql(dot)org
Subject: [NOVICE] Insert Question
hhi all,
long time no askie question, but here goes...
i want to insert sequential document numbers into a
products table
my current setup is like so:
product_number document_number
1001
1002
1006
1005
i want an insert statement that will yield the
following:
product_number document_number
1001 42000001
1002 42000002
1006 42000003
1005 42000004
relative order means nothing, but i do want sequential
document numbers.
how can i go about getting this done as efficiently as
possible?
as always, tia.
__________________________________________________________________________________________
Check out the New Yahoo! Mail - Fire up a more powerful email and get things done faster.
(http://advision.webevents.yahoo.com/mailbeta)
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
From | Date | Subject | |
---|---|---|---|
Next Message | A. Kretschmer | 2006-11-02 20:18:28 | Re: Insert Question |
Previous Message | Greg Lindstrom | 2006-11-02 20:07:59 | Number of fields in split() |