Doh! of course. Thanks.
On Thursday 30 January 2003 10:17, you wrote:
> Derek,
>
> > In Postgres, I have to use the 'get diagnostics var = result_oid'
> > statement
>
> to
>
> > get the oid of the new record, then do a select on the table to get the
> > sequence column value for the new record using this oid, to obtain the
> > new sequence value.
>
> Um, what's wrong with "select currval('sequence_name')" ?
--
Derek Clarkson
Web: http://users/bigpond/net/au/drekka
