BETWEEN SYMMETRIC/ASYMMETRIC

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: BETWEEN SYMMETRIC/ASYMMETRIC
Date: 2002-04-10 03:02:30
Message-ID: GNELIHDDFBOCMGBFGEFOCEANCCAA.chriskl@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 Content-Type Size
between.txt text/plain 4.0 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Gavin Sherry 2002-04-10 03:21:57 Re: BETWEEN SYMMETRIC/ASYMMETRIC
Previous Message Hiroshi Inoue 2002-04-10 02:46:04 Re: timeout implementation issues