Re: double precision vs. numeric

Поиск
Список
Период
Сортировка
От Aarni Ruuhimäki
Тема Re: double precision vs. numeric
Дата
Msg-id 200608250812.58794.aarni@kymi.com
обсуждение исходный текст
Ответ на Re: double precision vs. numeric  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: double precision vs. numeric  (Aarni Ruuhimäki <aarni@kymi.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: RES: Lock Problem
Следующее
От: Michael Fuhr
Дата:
Сообщение: Re: Importing data from csv