RE: [GENERAL] using Oids to retrieve a row - Mailing list 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.ofarrell@aersoft.ie]
    Sent:    Friday, March 26, 1999 5:39 AM
    To:    pgsql-general@postgreSQL.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.ofarrell@aersoft.ie              2 Northumberland
Avenue,
                                                   Dun Laoghaire,Co.
Dublin
        Direct Phone 353-1-2145950
                   Phone: 01-2301166   Fax: 01-2301167

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~