BETWEEN SYMMETRIC/ASYMMETRIC

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема BETWEEN SYMMETRIC/ASYMMETRIC
Дата
Msg-id GNELIHDDFBOCMGBFGEFOCEANCCAA.chriskl@familyhealth.com.au
обсуждение исходный текст
Ответы Re: BETWEEN SYMMETRIC/ASYMMETRIC  (Gavin Sherry <swm@linuxworld.com.au>)
Список pgsql-hackers
Hi all,

I've attached a patch for doing BETWEEN SYM/ASYM, however it just doesn't
work!!!

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

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

test=# select 2 between symmetric 3 and 1;
ERROR:  parser: parse error at or near "3"
test=# select 2 between asymmetric 3 and 1;
ERROR:  parser: parse error at or near "3"
test=# select 2 not between  3 and 1;
 ?column?
----------
 t
(1 row)

test=# select 2 not between symmetric 3 and 1;
ERROR:  parser: parse error at or near "3"

Can anyone see what's wrong?

Chris

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Hiroshi Inoue
Дата:
Сообщение: Re: timeout implementation issues
Следующее
От: Gavin Sherry
Дата:
Сообщение: Re: BETWEEN SYMMETRIC/ASYMMETRIC