Getting all entries in a single block with ctid - Mailing list pgsql-general

From Tore Halvorsen
Subject Getting all entries in a single block with ctid
Date
Msg-id CADGw-Sf5Jxs9FVOx1-whiTgFrPurFSvY-GJ3VqQ5Vfxt5b+DhQ@mail.gmail.com
Whole thread Raw
Responses Re: Getting all entries in a single block with ctid
List pgsql-general
Hi,

As I understand it, the ctid contains both the block number and an index is this block.
Is there a way to fetch all the table entries from the same block?

E.g. something like this:

select * from foo where ctid like '(123,%'

or ... ctid.block = 123

--
Eld på åren og sol på eng gjer mannen fegen og fjåg. [Jøtul]
<demo> 2012 Tore Halvorsen || +052 0553034554

pgsql-general by date:

Previous
From: Cefull Lo
Date:
Subject: Re: time zone problem
Next
From: "Tomas Vondra"
Date:
Subject: Re: Getting all entries in a single block with ctid