Postgres Pro
Downloads
Home   >   mailing lists

Re: 1.0 in function call not regarded as REAL in 7.3.2 - Mailing list pgsql-bugs

From Tom Lane
Subject Re: 1.0 in function call not regarded as REAL in 7.3.2
Date
Msg-id 8052.1061477350@sss.pgh.pa.us
Whole thread Raw
In response to 1.0 in function call not regarded as REAL in 7.3.2  (Boris Folgmann <misc@folgmann.com>)
List pgsql-bugs
Tree view 
Boris Folgmann <misc@folgmann.com> writes:
> Look closely: postmaster now thinks that the first argument 1.0 is NUMERIC,

Yup.  This is not a bug, it's intentional (and per SQL spec, AFAICT).

Your problem is that 123::real/25 yields a double precision result,
which is not implicitly castable to real anymore.  I'd suggest
switching the function arguments to double precision.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: postgresql 7.3.2 bug on date '1901-12-13' and '1901-12
Next
From: Stephan Szabo
Date:
Subject: Re: postgresql 7.3.2 bug on date '1901-12-13' and '1901-12