Re: How much clustered?

Tom Lane wrote:
> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> > Currently we output the ctid as a string:
> > snprintf(buf, sizeof(buf), "(%u,%u)", blockNumber, offsetNumber);
> > Perhaps someday we should consider outputting that as an array or a
> > result set:
>
> It's not an array, because the two components are not of the same data
> type; and it's not a result set, any more than (say) a point or a box
> is. What it is is a record datatype.
>
> There might be some usefulness to adding SQL functions to allow
> extraction of the block number and item number fields, though we'd have
> some problems with the lack of a uint4 datatype to represent the block
> number field's type. The demand for this has been too low to make me
> feel we need to expend that effort...

Agreed, I was just pointing out that someday it might need improvement.

--
Bruce Momjian http://candle.pha.pa.us
SRA OSS, Inc. http://www.sraoss.com

+ If your life is a hard drive, Christ can be your backup. +