Re: double precision vs. numeric

On Mon, Aug 28, 2006 at 11:08:50AM +0300, Aarni Ruuhimki wrote:
> Now I saw it again. In a terminal window after an insert from an application:
>
> WARNING: deprecated input syntax for type double precision: ""
> DETAIL: This input will be rejected in a future release of PostgreSQL.
>
> So this merely means that in future one can not insert empty values into field
> of type double precision ?

Right. 8.0 issues a warning and 8.1 gives an error:

8.0.8
test=> SELECT ''::double precision;
WARNING: deprecated input syntax for type double precision: ""
DETAIL: This input will be rejected in a future release of PostgreSQL.
float8
--------
0
(1 row)

8.1.4
test=> SELECT ''::double precision;
ERROR: invalid input syntax for type double precision: ""

--
Michael Fuhr