1.0 in function call not regarded as REAL in 7.3.2

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 'plpgsql' WITH (ISCACHABLE);

This works:

SELECT _rmin(1.0, CAST(123 AS REAL));
_rmin
-------
1
(1 Zeile)

This not:

SELECT _rmin(1.0, CAST(123 AS REAL)/25);
ERROR: Funktion _rmin(numeric, double precision) existiert nicht
Unable to identify a function that satisfies the given argument types
You may need to add explicit typecasts

Look closely: postmaster now thinks that the first argument 1.0 is NUMERIC,
but I added only the /25 for the _second_ argument!

cu,
boris

--
Dipl.-Inf. Boris Folgmann mailto:boris(at)folgmann(dot)de
TeamForge GmbH http://www.teamforge.de

Boris Folgmann <misc(at)folgmann(dot)com> 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 real anymore. I'd suggest
switching the function arguments to double precision.

regards, tom lane