Re: double precision vs. numeric

[Michael Fuhr <mike(at)fuhr(dot)org>]

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