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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

  From Date Subject
Next Message Mark Nelson 2001-08-14 14:48:32 find and replace content
Previous Message Gaetan GUYODO 2001-08-14 07:14:34 Re: standard sql operators