Re: Using CTID system column as a "temporary" primary key

[Christophe Pettus]

> On Mar 28, 2023, at 03:39, Sebastien Flaesch <sebastien.flae...@4js.com> 
> wrote:
> Do I have to cast() ?

Yes:

        select * from t where ctid='(0,1)'::tid;

The string representation can be up to 17 characters: 10 for the page number, 4 
for the tuple number, and three for the delimiters.

Remember that updating a row changes its CTID.