Re: Casting numeric values to double - Mailing list pgsql-general

From Daniel Schregenberger
Subject Re: Casting numeric values to double
Date
Msg-id 1128416445.8889.9.camel@localhost
Whole thread Raw
In response to Re: Casting numeric values to double  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
On Mon, 2005-10-03 at 17:44 +0200, Martijn van Oosterhout wrote:
> On Mon, Oct 03, 2005 at 03:31:42PM +0200, Daniel Schregenberger wrote:
> > I recently stumbled uppon the following thing:
> > If I compare a field of type "numeric" to a small decimal constant like
> > "3.6", the constant is interpreted as a "double precision" value and the
> > comparison fails with the following message:
> >
> > # SELECT * FROM tr_table_okpx WHERE prating >= 3.6;
> >
> > Unable to identify an operator '>=' for types 'double precision' and
> > 'numeric'
> >         You will have to retype this query using an explicit cast
>
> If at all possible, can the queries be arranged to output single quotes
> around the numbers? If you do that, the choice of type will be deferred
> until the point where it knows what "prating" is.

oh, I didn't think about untyping. I will try this as well, thanks!

> > I'm using Postgre 7.2, which might be a bit outdated but I could not find
> > any information whether this behaviour has changed in newer versions. So
>
> Yeah, it's better in later versions. Either explicitly typing (with
> ::numeric) or explicitly untyping (with single quotes) will work.

well, explicitly typing works in 7.2, I just wondered if that's the way
to go or if newer versions define implicit casts like for example C/C++
does: one operand is double -> the other has to be double too.
As far as I understood it now, it has changed and I will try to upgrade.

Thanks for your help! (Tom as well)

-- Daniel


--
http://www.despite.ch/ -- http://www.npfdd.ch/


Make sure your E-mail can be read by everyone!
http://www.betips.net/etc/evilmail.html

Please avoid sending me Word or PowerPoint attachments.
http://www.gnu.org/philosophy/no-word-attachments.html
--
You will obey or molten silver will be poured into your ears.

Attachment

pgsql-general by date:

Previous
From: "Thomas F. O'Connell"
Date:
Subject: Re: pg_dump output mode
Next
From: Zlatko Matić
Date:
Subject: Unbound text box, Text > 255 characters, MSAccess/PostgreSQL