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