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