I've nearly finished off the patch Christopher distributed.  Creates the
between node, and passes all regression tests except horology.  I need
to update outfuncs and readfuncs -- but hope to fix the below first.

Seems I have a funny case left (Note the last comparison should be
false):


regression=# select 3 between 2 and 4;
 ?column? 
----------
 t
(1 row)

regression=# select 5 between 2 and 4;
 ?column? 
----------
 f
(1 row)

regression=# select 1 between 2 and 4;
 ?column? 
----------
 f
(1 row)

regression=# select 3 between 2 and 4 and 5 between 2 and 4;
 ?column? 
----------
 f
(1 row)

regression=# select 3 between 2 and 4 and 3 between 2 and 4;
 ?column? 
----------
 t
(1 row)

regression=# select 3 between 2 and 4 and 1 between 2 and 4;
 ?column? 
----------
 t
(1 row)



The patch can be found at:
http://www.zort.ca/patches/postgresql_misc/between.patch

<a href="http://www.zort.ca/patches/postgresql_misc/between.patch";>PATCH
HERE</a>





---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster


Reply via email to