have an example :)
Bruno Wolff III wrote:
> On Thu, Oct 09, 2003 at 14:26:21 -0400,
> Gene Vital <genevital(at)karibe(dot)com> wrote:
>
>>when inserting new records into parent / child tables, what is the best
>>recommended way of retrieving the pkey value from the parent table when
>>using auto incrementing fields ?
>
>
> You want to use currval. currval will return the last value obtained
> by nextval in the same session, so it is safe to use without any additional
> locking.
>
--
Eugene Vital
Any technology indistinguishable from magic is insufficiently advanced.