Re: OID stuff

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Derek Clarkson <dhc(at)bigpond(dot)net(dot)au>, pgsql-novice(at)postgresql(dot)org
Subject: Re: OID stuff
Date: 2003-01-29 23:17:11
Message-ID: 200301291517.11840.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


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')" ?

--
-Josh Berkus
Aglio Database Solutions
San Francisco

In response to

  • OID stuff at 2003-01-29 23:04:54 from Derek Clarkson

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Juliet May 2003-01-29 23:25:06 Re: New and investigating
Previous Message Derek Clarkson 2003-01-29 23:04:54 OID stuff