Re: Get the offset of a tuple inside a table

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Pei He" <hepeimail(at)gmail(dot)com>,<pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Get the offset of a tuple inside a table
Date: 2010-09-21 22:47:53
Message-ID: 4C98EFC90200002500035AA1@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Pei He <hepeimail(at)gmail(dot)com> wrote:

> When I using an index scan, can I get the offset of the tuple in
> the table?

Well, regardless of the type of scan, you can select the ctid
column, which gives the block number and the tuple number within the
block.

-Kevin

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2010-09-21 23:05:39 Re: What happened to the is_<type> family of functions proposal?
Previous Message Tom Lane 2010-09-21 22:40:25 Re: Any reason why the default_with_oids GUC is still there?