pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Aarni Ruuhimäki <aarni@kymi.com>
To: pgsql-sql@postgresql.org
Subject: Re: double precision vs. numeric
Date: Fri, 25 Aug 2006 08:12:58 +0300
Message-ID: <200608250812.58794.aarni@kymi.com> (raw)
In-Reply-To: <7131.1156440586@sss.pgh.pa.us>
References: <200608241936.50752.aarni@kymi.com>
	<7131.1156440586@sss.pgh.pa.us>

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
-- 
Aarni Ruuhimäki

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




view thread (10+ messages)  latest in thread

Message-ID: <200608250812.58794.aarni@kymi.com>
Permalink:  ../200608250812.58794.aarni@kymi.com/
Also on:    postgresql.org/message-id/200608250812.58794.aarni@kymi.com

 · 

reply

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: <200608250812.58794.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