From: | Michael Davis <michael(dot)davis(at)prevuenet(dot)com> |
---|---|
To: | "'dave(at)aersoft(dot)ie'" <dave(at)aersoft(dot)ie>, pgsql-general(at)postgreSQL(dot)org |
Subject: | RE: [GENERAL] using Oids to retrieve a row |
Date: | 1999-03-26 15:39:02 |
Message-ID: | 93C04F1F5173D211A27900105AA8FCFC1452D9@lambic.prevuenet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I use the following technique:
add sequence to the primary key of the table
look up the sequence the primary key
insert a record using (including) the primary key
re-query the newly inserted record using the primary key
Thanks, Michael
-----Original Message-----
From: David O'Farrell [SMTP:dave(dot)ofarrell(at)aersoft(dot)ie]
Sent: Friday, March 26, 1999 5:39 AM
To: pgsql-general(at)postgreSQL(dot)org
Subject: [GENERAL] using Oids to retrieve a row
anyone know if it is possible to INSERT a row , "save" the oid for
this
row and subsequently select it based only on the oid ?
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~
David O'Farrell AerSoft Limited
mailto:dave(dot)ofarrell(at)aersoft(dot)ie 2 Northumberland
Avenue,
Dun Laoghaire,Co.
Dublin
Direct Phone 353-1-2145950
Phone: 01-2301166 Fax: 01-2301167
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~
From | Date | Subject | |
---|---|---|---|
Next Message | Ross J. Reedstrom | 1999-03-26 15:52:04 | Re: [GENERAL] Are postgreSQL views UPDATEable? |
Previous Message | David O'Farrell | 1999-03-26 12:39:14 | using Oids to retrieve a row |