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/