Re: select first occurrence of a table

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: gitarrerik(at)musiker(dot)nu
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: select first occurrence of a table
Date: 2003-05-02 21:06:49
Message-ID: 2503.1051909609@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

=?iso-8859-1?q?Erik=20Ronstr=F6m?= <kvarken(at)yahoo(dot)com> writes:
> If the table has OIDs (which is the default), you can use the OID as a
> unique identifier for a row.

You could also use CTID in the same way; this works on all tables.
It does require that no one else is trying to update the same row at
about the same time, though.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bob Krus 2003-05-02 21:07:24 PostgreSQL Inquiry
Previous Message Benjamin Scherrey 2003-05-02 20:26:27 Status of OIDs was: Re: select first occurrence of a table