"Neil Conway" <neilc@samurai.com> 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
