Re: Looking for help regarding getting the latest inserted sequence value. - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: Looking for help regarding getting the latest inserted sequence value.
Date
Msg-id 20070701105538.GA10690@svana.org
Whole thread Raw
In response to Re: Looking for help regarding getting the latest inserted sequence value.  (Richard Broersma Jr <rabroersma@yahoo.com>)
List pgsql-general
On Sat, Jun 30, 2007 at 11:21:59AM -0700, Richard Broersma Jr wrote:
> I don't want to derail the thread too much, but would it be nice if the returning could be used in
> a insert sub-query?

Absolutly, however the semantics are not so simple. I remember
something about when to invoke triggers? And what view should they get?
Does the trigger on the outer table get to see the effect of the nested
insert, for example.

I'm sure it will get done eventually, once the details have been sorted
out.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

Attachment

pgsql-general by date:

Previous
From: Michael Glaesemann
Date:
Subject: Re: Bitmap index?
Next
From: Magnus Hagander
Date:
Subject: Re: postgressqlnot support inwindows 2000