Re: [BUGS] 1.0 in function call not regarded as REAL in 7.3.2

2003-08-21 Thread Tom Lane
Boris Folgmann <[EMAIL PROTECTED]> writes: > Look closely: postmaster now thinks that the first argument 1.0 is NUMERIC, Yup. This is not a bug, it's intentional (and per SQL spec, AFAICT). Your problem is that 123::real/25 yields a double precision result, which is not implicitly castable to re

[BUGS] 1.0 in function call not regarded as REAL in 7.3.2

2003-08-21 Thread Boris Folgmann
Hi! I've triggered a type related problem in postgresql-7.3.2-3 It worked in postgresql-7.2.3-5.80. CREATE OR REPLACE FUNCTION _rmin(REAL, REAL) RETURNS REAL AS ' BEGIN IF $1 <= $2 THEN RETURN $1; ELSE RETURN $2; END IF; END; ' LANGUAGE 'plp