Re: Comparing fixed precision to floating (no anwer)

On Tue, 21 Aug 2001 15:41:22 -0600, Mike Finn wrote:

>I am using numeric(p,s) fields in a database schema.
>Using queries that contain a comparison like
>
>    ...
>    where numericField = 456.789
>    ....
>
>will generate an error
>
>   Unable to identify an operator '=' for types 'numeric' and 'float8'
>   You will have to retype this query using an explicit cast

I have the same problem but nobody seems to understand
that you can't always change the query like in my case,
where a comercial app. sends the query.
I tried the following with no avail.

create function numeric_eq(numeric,float8)
returns bool
as ''
language 'internal';

create operator = (
leftarg=numeric,
rightarg=float8,
procedure=numeric_eq,
commutator='=',
negator='<>',
restrict=eqsel,
join=eqjoinsel
);

The Problem is: It doesn't work and the backend process crashes and get's restarted.
I tried it with 7.03 and I guess 7.1.3 behaves the same.

Do you have any ideas? I agree, that should work in postresql.

regards

Johann

Johann Zuschlag
zuschlag@online.de