From: Tom Lane <tgl@sss.pgh.pa.us>
To: mdavis@sevainc.com <mdavis@sevainc.com>
Cc: 'pgsql-sql@postgresql.org' <pgsql-sql@postgresql.org>
Cc: 'pgsql-general@postgresql.org' <pgsql-general@postgresql.org>
Subject: Re: [SQL] Numeric and money
Date: Wed, 03 Jan 2001 15:36:49 -0500
Message-ID: <17683.978554209@sss.pgh.pa.us> (raw)
In-Reply-To: <01C07575.F26395D0.mdavis@sevainc.com>
References: <01C07575.F26395D0.mdavis@sevainc.com>
[ mail lists trimmed to something a tad more reasonable ]
Michael Davis <mdavis@sevainc.com> writes:
> From within Access, I can't update any table with a numeric data type
> because of the "select * from tst where amount = 1.1;" failure.
Yeah. The problem here is the conflict between interpreting '1.1' as
a "float8" constant vs. interpreting it as a "numeric" constant. In order
to fix this we need to settle on a better type promotion hierarchy among
the various numeric datatypes. You can find past discussions of the
issue in the pghackers archives. I made a proposal on 13-May-2000 that
I think was objected to by some people, though I don't recall exactly
why.
regards, tom lane
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-interfaces@postgresql.org
Cc: tgl@sss.pgh.pa.us, mdavis@sevainc.com, pgsql-sql@postgresql.org, pgsql-general@postgresql.org
Subject: Re: [SQL] Numeric and money
In-Reply-To: <17683.978554209@sss.pgh.pa.us>
* 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