Re: Weird type selection choice

I wrote:
> I noticed this problem in 8.2 and 8.3:
>
> pei=# select mod( trunc( 1 ), 2 );
> ERROR:  42883: function mod(double precision, integer) does not exist
> LINE 1: select mod( trunc( 1 ), 2 );
>                ^

I suppose there will be little interest in including the obvious solution, 
namely

CREATE FUNCTION pg_catalog.trunc(int) RETURNS int AS $$ SELECT $1; $$ LANGUAGE 
SQL STRICT IMMUTABLE;

into PostgreSQL.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/