Re: [GENERAL] Re: Comparing fixed precision to floating (no anwer)

2001-08-23 Thread Johann Zuschlag
g savvy can help us out further. Maybe :-) regards Johann Johann Zuschlag [EMAIL PROTECTED] ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] Overwriting Operator for numeric and float8 fails

2001-08-20 Thread Johann Zuschlag
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 '' >lan

[GENERAL] Overwriting Operator for numeric and float8 fails

2001-08-19 Thread Johann Zuschlag
perator = ( 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