Re: Weird type selection choice

Peter Eisentraut wrote:
> 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;

It does sound totally useless...

Why would you run a query like that in the first place? It seems like a 
useless query as it is. Is there a bigger story behind it?

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com