Port Bug Report: Parser error

From: Unprivileged user <nobody>
To: pgsql-ports(at)postgresql(dot)org
Subject: Port Bug Report: Parser error
Date: 1998-12-31 10:05:50
Message-ID: 199812311005.FAA27157@hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-ports


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

Your name : Nicolas GIMMILLARO
Your email address : nicolas(at)wmi(dot)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:
---------

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

Browse pgsql-ports by date

  From Date Subject
Next Message Unprivileged user 1998-12-31 16:17:23 Port Bug Report: \d displays view? where should be table not consistant
Previous Message Abdul Wahid Tanner 1998-12-30 06:23:20 initdb problems