More fun with BETWEEN - Mailing list pgsql-hackers

From Rod Taylor
Subject More fun with BETWEEN
Date
Msg-id 1026188415.18174.13.camel@jester
Whole thread Raw
Responses Re: More fun with BETWEEN
List pgsql-hackers
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>






pgsql-hackers by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: Proposal: CREATE CONVERSION
Next
From: Tatsuo Ishii
Date:
Subject: Re: Proposal: CREATE CONVERSION