| From: | Jochen Topf <sqrt(at)eldorado(dot)inka(dot)de> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Negative integer constants don't work with "between" operator. |
| Date: | 1999-08-28 20:22:16 |
| Message-ID: | 19990828222216.A7712@eldorado.inka.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Jochen Topf
Your email address : jochen(at)remote(dot)org
System Configuration
---------------------
Architecture (example: Intel Pentium) : Intel Pentium
Operating System (example: Linux 2.0.26 ELF) : Linux 2.0.35, RedHat 5.2
PostgreSQL version (example: PostgreSQL-6.5.1): PostgreSQL-6.5.1
Compiler used (example: gcc 2.8.0) : RPMs vom ftp.postgresql.org
Please enter a FULL description of your problem:
------------------------------------------------
Negative integer constants don't work with "between" operator.
Please describe a way to repeat the problem. Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------
This works:
test=> create table x (y int check (y >= -1 AND y <=99) );
CREATE
This doesn't:
test=> create table x (y int check (y between -1 and 99) );
ERROR: parser: parse error at or near "-"
If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 1999-08-29 20:20:10 | Re: [BUGS] Error in Makefile |
| Previous Message | Tom Lane | 1999-08-26 19:12:35 | Re: [BUGS] Error in Makefile |