Re: Overwriting Operator for numeric and float8 fails - Mailing list 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@online.de