"Neil Conway" <[EMAIL PROTECTED]> wrote
> > Does it make sense to implementation > or < for the tid type?
>
> I can't get too excited about it, but I wouldn't object if someone can
> see a use for it.
>
There might be another usage of tid < or >. Consider a heap with one middle
page is broken, I could save most of my data by doing
INSERT INTO aa SELECT * FROM a WHERE ctid < '(1000, 1)';
INSERT INTO aa SELECT * FROM a WHERE ctid > '(1001, 0)';
The above example also proves that <= or >= is not required.
Regards,
Qingqing
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
