"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.


---------------------------(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

Reply via email to