Port Bug Report: Parser error - Mailing list pgsql-ports

From Unprivileged user
Subject Port Bug Report: Parser error
Date
Msg-id 199812311005.FAA27157@hub.org
Whole thread Raw
List pgsql-ports
============================================================================
                        POSTGRESQL BUG REPORT TEMPLATE
============================================================================


Your name        : Nicolas GIMMILLARO
Your email address    : nicolas@wmi.fr

Category        : runtime: back-end: SQL
Severity        : non-critical

Summary: Parser error

System Configuration
--------------------
  Operating System   : Linux 2.0.36 ELF (Slackware)

  PostgreSQL version : 6.4.1

  Compiler used      : 2.7.2

Hardware:
---------
P200 MMX, 96 M RAM , 4.1 Go SCSI
Linux wmi 2.0.36 #1 Fri Dec 18 09:57:18 MET 1998 i586


Versions of other tools:
------------------------
GNU Make version 3.74
flex version 2.5.4

--------------------------------------------------------------------------

Problem Description:
--------------------
When using a 'IN (..,..,..)' statment with a negativ number, I get a parser error

--------------------------------------------------------------------------

Test Case:
----------
wmi=> select * from devis where no_devis in (-1,0,1,2);
ERROR:  parser: parse error at or near "-"


--------------------------------------------------------------------------

Solution:
---------


--------------------------------------------------------------------------


pgsql-ports by date:

Previous
From: "Abdul Wahid Tanner"
Date:
Subject: initdb problems
Next
From: Unprivileged user
Date:
Subject: Port Bug Report: \d displays view? where should be table not consistant