Re: ROWID ? or other internal ID

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: valcauda Stéphane <valcauda(dot)aderis(at)wanadoo(dot)fr>
Cc: "PostgreSQL Mailing List" <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: ROWID ? or other internal ID
Date: 2002-10-09 04:55:53
Message-ID: 17384.1034139353@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

=?iso-8859-1?Q?valcauda_St=E9phane?= <valcauda(dot)aderis(at)wanadoo(dot)fr> writes:
> In other database like ORACLE or PROGRESS you've got an internal identifier
> ROWID or RECID
> (bookmark with access) which allow you to select a row very quickly or to go
> back to a specific row very quickly.
> these functions uses an internal ID.

CTID allows direct access to a row --- but it's invalidated by an
update, so it might not be very useful for you.

regards, tom lane

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message iloz 2002-10-09 09:35:52 Re: ROWID ? or other internal ID
Previous Message Jean-Luc Lachance 2002-10-08 17:18:57 Re: ROWID ? or other internal ID