More fun with BETWEEN

Поиск
Список
Период
Сортировка
От Rod Taylor
Тема More fun with BETWEEN
Дата
Msg-id 1026188415.18174.13.camel@jester
обсуждение исходный текст
Ответы Re: More fun with BETWEEN  (Rod Taylor <rbt@zort.ca>)
Список 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 по дате отправления:

Предыдущее
От: Tatsuo Ishii
Дата:
Сообщение: Re: Proposal: CREATE CONVERSION
Следующее
От: Tatsuo Ishii
Дата:
Сообщение: Re: Proposal: CREATE CONVERSION