Getting sequence value after inserting many rows at a time

From: Maurício Sessue Otta <mauricio(at)cristorei(dot)com(dot)br>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Getting sequence value after inserting many rows at a time
Date: 2003-01-10 00:48:11
Message-ID: 010901c2b841$f429f290$830101c0@mauricio1
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

I have a PHP script that do something like this:

INSERT INTO table_with_sequence (field1, field2...., fieldn)
SELECT field1, field2, ..., fieldn FROM table,table
WHERE condition, condition

My doubt:
Will the rows just inserted in "table_with_sequence" always be sequencial?
(won't it happen to have X rows from this INSERT, 1 rows from another INSERT
in the middle and the rest rows of the first INSERT?)

How can I safely get the first value the INSERT "generated" for
the sequence?

[]'s Mauricio

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Bruno Wolff III 2003-01-10 01:25:15 Re: Getting sequence value after inserting many rows at a time
Previous Message Bruno Wolff III 2003-01-10 00:38:54 Re: [SQL] Search and Replace