Re: <> operator

"Neil Conway" <neilc(at)samurai(dot)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