Bug in parser

Lists: 토토 커뮤니티 PostgreSQL : PostgreSQL 메일 링리스트 : 1999-01-11 이후 PGSQL-BUGS.
From: Andriy I Pilipenko <bamby(at)marka(dot)net(dot)ua>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bug in parser
Date: 1999-01-11 09:51:34
Message-ID: Pine.BSF.4.05.9901111139260.538-100000@pai.marka.net.ua
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: 토토 커뮤니티 PostgreSQL : PostgreSQL 메일 링리스트 : 1999-01-11 이후 PGSQL-BUGS.

============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================

Your name : Andriy I Pilipenko
Your email address : bamby(at)marka(dot)net(dot)ua

System Configuration
---------------------
Architecture (example: Intel Pentium) : i486 and higher

Operating System (example: Linux 2.0.26 ELF) : FreeBSD 2.2.6
FreeBSD 2.2.7
Linux 2.0.34 ELF

PostgreSQL version (example: PostgreSQL-6.4.2) : PostgreSQL-6.4
PostgreSQL-6.4.2

Compiler used (example: gcc 2.8.0) : gcc 2.7.2.1

Please enter a FULL description of your problem:
------------------------------------------------

Backend reports syntax error near unary '-' in queries like:

SELECT * FROM some_table WHERE some_column IN ( <negative number> )
^^^^^^^^^^^^^^^^^^^^^^^^
This bug not existed in 6.3.2. It first appeared in 6.4 and remains in
6.4.2.

Please describe a way to repeat the problem. Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------

Bug is very easy to reproduce. See query above.

If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------