Re: Multiple Inserts

On Fri, Jul 22, 2005 at 01:49:25PM -0700, operationsengineer1(at)yahoo(dot)com wrote:
>
> i need to insert multiple serial numbers at a time
> (eg, 100). my current idea is to allow the user to
> enter a beginning serial number, an ending serial
> number and then use php to iterate through the numbers
> and insert them (i'm thinking multiple inserts (get
> value -> insert, get 2nd value -> insert, get 3rd
> value, insert, etc...) unless someone can give me an
> idea how to collect the data then do one big insert).

In 8.0 you can use INSERT ... SELECT and generate_series():

http://www.postgresql.org/docs/8.0/static/sql-insert.html
http://www.postgresql.org/docs/8.0/static/functions-srf.html

Example:

INSERT INTO foo (serialnum) SELECT * FROM generate_series(1, 100);

Although older versions of PostgreSQL don't have generate_series(),
it's trivial to write with PL/pgSQL or other languages. Read up
on set-returning functions or search the archives for examples.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/