On Sun, 19 Aug 2001 10:23:39 +0200, Johann Zuschlag wrote:
>I get the following error: Unable to identify an operator '=' for types 'numeric' and
>'float8'...
>create function numeric_eq(numeric,float8)
>returns bool
>as ''
>language 'internal';
>
>create operator = (
>leftarg=numeric,
>righ
I think you have a syntax error in the SELECT
statement. What is RECHNUNG? The only table reference
that I see is t6.
If RECHNUNG is the database, connect to the database
and try:
Select * from t6 where bruttosum = 0034.70
order by nummer desc;
Best of luck,
Andrew Gould
--- Johann Zusch
Hi,
My application does queries like this:
SELECT t6.* FROM RECHNUNG t6 WHERE t6.bruttosumm = 0034.70 ORDER BY t6.nummer DESC
I get the following error: Unable to identify an operator '=' for types 'numeric' and
'float8'...
and of course the same for the operator '<>'.
Ok, ok quotes miss
