| From: | Derek Clarkson <dhc(at)bigpond(dot)net(dot)au> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | OID stuff |
| Date: | 2003-01-29 23:04:54 |
| Message-ID: | 200301301004.54693.dhc@bigpond.net.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Ahh,
Thanks guys. I think I have it now. I've also been looking for a way to get
the id of a newly created record. Using MS SQL (pha! blah! cough! ;-) I could
use the scope_identity function to get the id of the record I have just
created for placing in foreign keys in subsequent inserts in other tables.
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.
Is this the best way to do this ?
cio
--
Derek Clarkson
Web: http://users/bigpond/net/au/drekka
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2003-01-29 23:17:11 | Re: OID stuff |
| Previous Message | Alain Gougeon | 2003-01-29 22:56:08 | Re: New and investigating |