| 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: | Whole Thread | Raw Message | 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 |
| 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 |