BETWEEN SYMMETRIC/ASYMMETRIC - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject BETWEEN SYMMETRIC/ASYMMETRIC
Date
Msg-id GNELIHDDFBOCMGBFGEFOCEANCCAA.chriskl@familyhealth.com.au
Whole thread Raw
Responses Re: BETWEEN SYMMETRIC/ASYMMETRIC  (Gavin Sherry <swm@linuxworld.com.au>)
List 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

Attachment

pgsql-hackers by date:

Previous
From: Hiroshi Inoue
Date:
Subject: Re: timeout implementation issues
Next
From: Gavin Sherry
Date:
Subject: Re: BETWEEN SYMMETRIC/ASYMMETRIC