Skip site navigation (1) Skip section navigation (2)

Insert Question

From: <operationsengineer1(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Insert Question
Date: 2006-11-02 20:01:51
Message-ID: 20061102200151.96558.qmail@web33305.mail.mud.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-novice
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) 


Responses

pgsql-novice by date

Next:From: Greg LindstromDate: 2006-11-02 20:07:59
Subject: Number of fields in split()
Previous:From: Tom LaneDate: 2006-11-02 17:44:58
Subject: Re: Inserting Money Types

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group