Re: double precision vs. numeric

From: Aarni Ruuhimäki <aarni(at)kymi(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: double precision vs. numeric
Date: 2006-08-25 05:12:58
Message-ID: 200608250812.58794.aarni@kymi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Thursday 24 August 2006 20:29, Tom Lane wrote:
> Aarni =?iso-8859-1?q?Ruuhim=E4ki?= <aarni(at)kymi(dot)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**

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Fuhr 2006-08-25 06:06:14 Re: Importing data from csv
Previous Message Tom Lane 2006-08-25 04:29:54 Re: RES: Lock Problem