Re: double precision vs. numeric - Mailing list pgsql-sql

From Aarni Ruuhimäki
Subject Re: double precision vs. numeric
Date
Msg-id 200608250812.58794.aarni@kymi.com
Whole thread Raw
In response to Re: double precision vs. numeric  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: double precision vs. numeric  (Aarni Ruuhimäki <aarni@kymi.com>)
List pgsql-sql
On Thursday 24 August 2006 20:29, Tom Lane wrote:
> Aarni Ruuhimäki <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
--
Aarni Ruuhimäki

**Kmail**
**Fedora Core Linux**



pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: RES: Lock Problem
Next
From: Michael Fuhr
Date:
Subject: Re: Importing data from csv