On 16 Leden 2012, 15:07, Tore Halvorsen wrote: > 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
WHERE ctid >= '(123,0)'::tid AND ctid < '(124,0)'::tid Tomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
