Skip site navigation (1) Skip section navigation (2)

Re: Overwriting Operator for numeric and float8 fails

From: "Johann Zuschlag" <zuschlag(at)online(dot)de>
To: "Andrew McMillan" <andrew(at)catalyst(dot)net(dot)nz>
Cc: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Overwriting Operator for numeric and float8 fails
Date: 2001-08-14 09:12:44
Message-ID: E15WaC3-0005pp-00@mrelay01.kundenserver.de (view raw or flat)
Thread:
Lists: pgsql-novice
On Tue, 14 Aug 2001 16:24:43 +1200, Andrew McMillan wrote:

>> SELECT t6.* FROM RECHNUNG  t6 WHERE t6.bruttosumm = 00000034.70 ORDER BY t6.nummer DESC
>
>Can't you just force conversion of the constant to numeric?
>
>SELECT t6.* FROM RECHNUNG  t6 WHERE t6.bruttosumm = numeric(00000034.70)
>ORDER BY t6.nummer DESC
>
As I said, my application is doing it. Only thing I did, was patching the ODBC-driver
to put quotes. That is the same like your proposal. But since I can't change my app.
I'm, looking for a smarter way.

Thanks anyway

Johann

Johann Zuschlag
zuschlag(at)online(dot)de



In response to

pgsql-novice by date

Next:From: Mark NelsonDate: 2001-08-14 14:48:32
Subject: find and replace content
Previous:From: Gaetan GUYODODate: 2001-08-14 07:14:34
Subject: Re: standard sql operators

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group