BETWEEN SYMMETRIC/ASYMMETRIC
BETWEEN SYMMETRIC/ASYMMETRIC
От:
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
Дата:
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
