From: Aarni Ruuhimäki <aarni@kymi.com>
To: pgsql-sql@postgresql.org
Subject: Re: double precision vs. numeric
Date: Mon, 28 Aug 2006 11:08:50 +0300
Message-ID: <200608281108.50394.aarni@kymi.com> (raw)
In-Reply-To: <200608250812.58794.aarni@kymi.com>
References: <200608241936.50752.aarni@kymi.com>
<7131.1156440586@sss.pgh.pa.us>
<200608250812.58794.aarni@kymi.com>
On Friday 25 August 2006 08:12, Aarni Ruuhimäki wrote:
> On Thursday 24 August 2006 20:29, Tom Lane wrote:
> > Aarni =?iso-8859-1?q?Ruuhim=E4ki?= <aarni@kymi.com> writes:
> > > I vaguely remember having seen a message
> > > ' ... type double precision ... will be depreciated / unsupported in
> > > future releases ... '
> > > or something like that somewhere. (?)
> >
> > Perhaps you are thinking of type "money"? DOUBLE PRECISION is in the
> > SQL standard, it's certainly not going anywhere.
> >
> > regards, tom lane
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 9: In versions below 8.0, the planner will ignore your desire to
> > choose an index scan if your joining column's datatypes do not
> > match
>
> Well, I have used it for 'money type' like sums and prices but I have never
> used the actual "money" data type.
>
> So, false alarm.
>
> Thank you guys !
>
> Aarni
Hi,
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 ?
BR,
Aarni
--
Aarni Ruuhimäki
**Kmail**
**Fedora Core Linux**
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: aarni@kymi.com
Subject: Re: double precision vs. numeric
In-Reply-To: <200608281108.50394.aarni@kymi.com>
* 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