Thread

General Bug Report: Error parsing negative numbers

Unprivileged user <nobody> — 1999-06-21T07:49:00Z

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


Your name               : Sverre H. Huseby
Your email address      : shh@computas.no

Category                : unknown
Severity                : serious

Summary: Error parsing negative numbers

System Configuration
--------------------
  Operating System   : Linux, Solaris

  PostgreSQL version : 6.5

  Compiler used      : egcs (Linux), gcc (Solaris)

Hardware:
---------
2.0.34, pentium

Versions of other tools:
------------------------


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

Problem Description:
--------------------
Negative numbers with more than a certain number og
digits produce an error message when being parsed.
Didn't see this problem on 6.4.x.

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

Test Case:
----------
wox=> select -0.123456789012345;
          ?column?
------------------
-0.123456789012345
(1 row)

wox=> select -0.1234567890123456;
ERROR:  Unable to convert left operator '-' from type 'unknown'


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

Solution:
---------
I flagged this as serious, as applications that worked
before may stop working (as happened for me). The temporary
solution is to rewrite applications to limit the number
of digits sent to PostgreSQL.

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