pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feeddouble precision vs. numeric
10+ messages / 5 participants
[nested] [flat]
* double precision vs. numeric
@ 2006-08-24 16:36 Aarni Ruuhimäki <aarni@kymi.com>
2006-08-24 16:51 ` Re: double precision vs. numeric Peter Eisentraut <peter_e@gmx.net>
2006-08-24 17:29 ` Re: double precision vs. numeric Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 2 replies; 10+ messages in thread
From: Aarni Ruuhimäki @ 2006-08-24 16:36 UTC (permalink / raw)
To: pgsql-sql
Hello,
Not sure if this is the right list to ask ...
I vaguely remember having seen a message
' ... type double precision ... will be depreciated / unsupported in future
releases ... '
or something like that somewhere. (?)
I have quite a few older dbs with tables that have one or more fields type
double precision and have so far upgraded ok since 7.0.x (I now use numeric
with appropriate precision and scale.)
Is there something to worry about when upgrading next time ? Start changing
these to numeric perhaps ?
Running 8.0.2 at the moment.
Best regards to all,
Aarni
--
Aarni Ruuhimäki
**Kmail**
**Fedora Core Linux**
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: double precision vs. numeric
2006-08-24 16:36 double precision vs. numeric Aarni Ruuhimäki <aarni@kymi.com>
@ 2006-08-24 16:51 ` Peter Eisentraut <peter_e@gmx.net>
2006-08-24 17:24 ` Re: double precision vs. numeric Michael Fuhr <mike@fuhr.org>
1 sibling, 1 reply; 10+ messages in thread
From: Peter Eisentraut @ 2006-08-24 16:51 UTC (permalink / raw)
To: pgsql-sql; aarni@kymi.com
Aarni Ruuhimäki wrote:
> ' ... type double precision ... will be depreciated / unsupported in
> future releases ... '
That is completely false.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: double precision vs. numeric
2006-08-24 16:36 double precision vs. numeric Aarni Ruuhimäki <aarni@kymi.com>
2006-08-24 16:51 ` Re: double precision vs. numeric Peter Eisentraut <peter_e@gmx.net>
@ 2006-08-24 17:24 ` Michael Fuhr <mike@fuhr.org>
0 siblings, 0 replies; 10+ messages in thread
From: Michael Fuhr @ 2006-08-24 17:24 UTC (permalink / raw)
To: Peter Eisentraut <peter_e@gmx.net>; +Cc: pgsql-sql; aarni@kymi.com
On Thu, Aug 24, 2006 at 06:51:33PM +0200, Peter Eisentraut wrote:
> Aarni Ruuhimäki wrote:
> > ' ... type double precision ... will be depreciated / unsupported in
> > future releases ... '
>
> That is completely false.
Presumably because double precision is standard SQL and has been
so for a long time. Perhaps Aarni is thinking about the money type,
which the documentation does say is deprecated.
--
Michael Fuhr
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: double precision vs. numeric
2006-08-24 16:36 double precision vs. numeric Aarni Ruuhimäki <aarni@kymi.com>
@ 2006-08-24 17:29 ` Tom Lane <tgl@sss.pgh.pa.us>
2006-08-25 05:12 ` Re: double precision vs. numeric Aarni Ruuhimäki <aarni@kymi.com>
1 sibling, 1 reply; 10+ messages in thread
From: Tom Lane @ 2006-08-24 17:29 UTC (permalink / raw)
To: aarni@kymi.com; +Cc: pgsql-sql
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
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: double precision vs. numeric
2006-08-24 16:36 double precision vs. numeric Aarni Ruuhimäki <aarni@kymi.com>
2006-08-24 17:29 ` Re: double precision vs. numeric Tom Lane <tgl@sss.pgh.pa.us>
@ 2006-08-25 05:12 ` Aarni Ruuhimäki <aarni@kymi.com>
2006-08-28 08:08 ` Re: double precision vs. numeric Aarni Ruuhimäki <aarni@kymi.com>
0 siblings, 1 reply; 10+ messages in thread
From: Aarni Ruuhimäki @ 2006-08-25 05:12 UTC (permalink / raw)
To: pgsql-sql
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**
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: double precision vs. numeric
2006-08-24 16:36 double precision vs. numeric Aarni Ruuhimäki <aarni@kymi.com>
2006-08-24 17:29 ` Re: double precision vs. numeric Tom Lane <tgl@sss.pgh.pa.us>
2006-08-25 05:12 ` Re: double precision vs. numeric Aarni Ruuhimäki <aarni@kymi.com>
@ 2006-08-28 08:08 ` Aarni Ruuhimäki <aarni@kymi.com>
2006-08-28 13:08 ` Re: double precision vs. numeric Michael Fuhr <mike@fuhr.org>
0 siblings, 1 reply; 10+ messages in thread
From: Aarni Ruuhimäki @ 2006-08-28 08:08 UTC (permalink / raw)
To: pgsql-sql
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**
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: double precision vs. numeric
2006-08-24 16:36 double precision vs. numeric Aarni Ruuhimäki <aarni@kymi.com>
2006-08-24 17:29 ` Re: double precision vs. numeric Tom Lane <tgl@sss.pgh.pa.us>
2006-08-25 05:12 ` Re: double precision vs. numeric Aarni Ruuhimäki <aarni@kymi.com>
2006-08-28 08:08 ` Re: double precision vs. numeric Aarni Ruuhimäki <aarni@kymi.com>
@ 2006-08-28 13:08 ` Michael Fuhr <mike@fuhr.org>
2006-08-28 13:32 ` Re: double precision vs. numeric Aarni Ruuhimäki <aarni@kymi.com>
0 siblings, 1 reply; 10+ messages in thread
From: Michael Fuhr @ 2006-08-28 13:08 UTC (permalink / raw)
To: Aarni Ruuhimäki <aarni@kymi.com>; +Cc: pgsql-sql
On Mon, Aug 28, 2006 at 11:08:50AM +0300, Aarni Ruuhimki wrote:
> 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 ?
Right. 8.0 issues a warning and 8.1 gives an error:
8.0.8
test=> SELECT ''::double precision;
WARNING: deprecated input syntax for type double precision: ""
DETAIL: This input will be rejected in a future release of PostgreSQL.
float8
--------
0
(1 row)
8.1.4
test=> SELECT ''::double precision;
ERROR: invalid input syntax for type double precision: ""
--
Michael Fuhr
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: double precision vs. numeric
2006-08-24 16:36 double precision vs. numeric Aarni Ruuhimäki <aarni@kymi.com>
2006-08-24 17:29 ` Re: double precision vs. numeric Tom Lane <tgl@sss.pgh.pa.us>
2006-08-25 05:12 ` Re: double precision vs. numeric Aarni Ruuhimäki <aarni@kymi.com>
2006-08-28 08:08 ` Re: double precision vs. numeric Aarni Ruuhimäki <aarni@kymi.com>
2006-08-28 13:08 ` Re: double precision vs. numeric Michael Fuhr <mike@fuhr.org>
@ 2006-08-28 13:32 ` Aarni Ruuhimäki <aarni@kymi.com>
2006-08-28 13:45 ` Re: double precision vs. numeric Michael Fuhr <mike@fuhr.org>
2006-08-28 13:49 ` Re: double precision vs. numeric D'Arcy J.M. Cain <darcy@druid.net>
0 siblings, 2 replies; 10+ messages in thread
From: Aarni Ruuhimäki @ 2006-08-28 13:32 UTC (permalink / raw)
To: Michael Fuhr <mike@fuhr.org>; +Cc: pgsql-sql
On Monday 28 August 2006 16:08, you wrote:
> > So this merely means that in future one can not insert empty values into
> > field of type double precision ?
>
> Right. 8.0 issues a warning and 8.1 gives an error:
>
Ok, thanks.
But NULLs will go in the future too ?
BR,
Aarni
--
Aarni Ruuhimäki
**Kmail**
**Fedora Core Linux**
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: double precision vs. numeric
2006-08-24 16:36 double precision vs. numeric Aarni Ruuhimäki <aarni@kymi.com>
2006-08-24 17:29 ` Re: double precision vs. numeric Tom Lane <tgl@sss.pgh.pa.us>
2006-08-25 05:12 ` Re: double precision vs. numeric Aarni Ruuhimäki <aarni@kymi.com>
2006-08-28 08:08 ` Re: double precision vs. numeric Aarni Ruuhimäki <aarni@kymi.com>
2006-08-28 13:08 ` Re: double precision vs. numeric Michael Fuhr <mike@fuhr.org>
2006-08-28 13:32 ` Re: double precision vs. numeric Aarni Ruuhimäki <aarni@kymi.com>
@ 2006-08-28 13:45 ` Michael Fuhr <mike@fuhr.org>
1 sibling, 0 replies; 10+ messages in thread
From: Michael Fuhr @ 2006-08-28 13:45 UTC (permalink / raw)
To: Aarni Ruuhimäki <aarni@kymi.com>; +Cc: pgsql-sql
On Mon, Aug 28, 2006 at 04:32:31PM +0300, Aarni Ruuhimki wrote:
> On Monday 28 August 2006 16:08, you wrote:
> > > So this merely means that in future one can not insert empty values into
> > > field of type double precision ?
> >
> > Right. 8.0 issues a warning and 8.1 gives an error:
>
> Ok, thanks.
>
> But NULLs will go in the future too ?
Only if Chris Date takes over the project ;-)
--
Michael Fuhr
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: double precision vs. numeric
2006-08-24 16:36 double precision vs. numeric Aarni Ruuhimäki <aarni@kymi.com>
2006-08-24 17:29 ` Re: double precision vs. numeric Tom Lane <tgl@sss.pgh.pa.us>
2006-08-25 05:12 ` Re: double precision vs. numeric Aarni Ruuhimäki <aarni@kymi.com>
2006-08-28 08:08 ` Re: double precision vs. numeric Aarni Ruuhimäki <aarni@kymi.com>
2006-08-28 13:08 ` Re: double precision vs. numeric Michael Fuhr <mike@fuhr.org>
2006-08-28 13:32 ` Re: double precision vs. numeric Aarni Ruuhimäki <aarni@kymi.com>
@ 2006-08-28 13:49 ` D'Arcy J.M. Cain <darcy@druid.net>
1 sibling, 0 replies; 10+ messages in thread
From: D'Arcy J.M. Cain @ 2006-08-28 13:49 UTC (permalink / raw)
To: aarni@kymi.com; +Cc: mike@fuhr.org; pgsql-sql
On Mon, 28 Aug 2006 16:32:31 +0300
Aarni Ruuhimäki <aarni@kymi.com> wrote:
> > > So this merely means that in future one can not insert empty values into
> > > field of type double precision ?
> >
> > Right. 8.0 issues a warning and 8.1 gives an error:
>
> But NULLs will go in the future too ?
No, NULL has always been the correct way to insert a non-value into a
field. Text/char type fields are the only ones where an empty string
is a valid value.
--
D'Arcy J.M. Cain <darcy@druid.net> | Democracy is three wolves
http://www.druid.net/darcy/ | and a sheep voting on
+1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner.
^ permalink raw reply [nested|flat] 10+ messages in thread
end of thread, other threads:[~2006-08-28 13:49 UTC | newest]
Thread overview: 10+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-08-24 16:36 double precision vs. numeric Aarni Ruuhimäki <aarni@kymi.com>
2006-08-24 16:51 ` Peter Eisentraut <peter_e@gmx.net>
2006-08-24 17:24 ` Michael Fuhr <mike@fuhr.org>
2006-08-24 17:29 ` Tom Lane <tgl@sss.pgh.pa.us>
2006-08-25 05:12 ` Aarni Ruuhimäki <aarni@kymi.com>
2006-08-28 08:08 ` Aarni Ruuhimäki <aarni@kymi.com>
2006-08-28 13:08 ` Michael Fuhr <mike@fuhr.org>
2006-08-28 13:32 ` Aarni Ruuhimäki <aarni@kymi.com>
2006-08-28 13:45 ` Michael Fuhr <mike@fuhr.org>
2006-08-28 13:49 ` D'Arcy J.M. Cain <darcy@druid.net>
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