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: (view raw, whole thread or download thread mbox)
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

i want an insert statement that will yield the

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

as always, tia.

Check out the New Yahoo! Mail - Fire up a more powerful email and get things done faster. 


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-2017 The PostgreSQL Global Development Group