Horton

Thread

  1. Bug in parser

    Andriy I Pilipenko <bamby@marka.net.ua> — 1999-01-11T09:51:34Z

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


Your name		:	Andriy I Pilipenko
Your email address	:	bamby@marka.net.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:
---------------------------------------------------------------------