Date: Thu, 9 Jan 2003 19:25:15 -0600
From: Bruno Wolff III <bruno@wolff.to>
To: =?iso-8859-1?Q?Maur=EDcio?= Sessue Otta <mauricio@cristorei.com.br>
Cc: pgsql-sql@postgresql.org
Subject: Re: Getting sequence value after inserting many rows at a time
Message-ID: <20030110012515.GA22248@wolff.to>
Mail-Followup-To: =?iso-8859-1?Q?Maur=EDcio?= Sessue Otta
	<mauricio@cristorei.com.br>, pgsql-sql@postgresql.org
References: <010901c2b841$f429f290$830101c0@mauricio1>
Mime-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <010901c2b841$f429f290$830101c0@mauricio1>
User-Agent: Mutt/1.3.25i

On Thu, Jan 09, 2003 at 22:48:11 -0200,
  Maurício Sessue Otta <mauricio@cristorei.com.br> wrote:
> 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?

You might want to reconsider the design. You might want to use another
serial column to indicate the grouping. This will allow you to pick out
records inserted as a group.