From: Michael Fuhr <mike@fuhr.org>
To: Aarni Ruuhimäki <aarni@kymi.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: double precision vs. numeric
Date: Mon, 28 Aug 2006 07:08:27 -0600
Message-ID: <20060828130827.GB4094@winnie.fuhr.org> (raw)
In-Reply-To: <200608281108.50394.aarni@kymi.com>
References: <200608241936.50752.aarni@kymi.com>
<7131.1156440586@sss.pgh.pa.us>
<200608250812.58794.aarni@kymi.com>
<200608281108.50394.aarni@kymi.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mike@fuhr.org, aarni@kymi.com
Subject: Re: double precision vs. numeric
In-Reply-To: <20060828130827.GB4094@winnie.fuhr.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox