Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-odbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group