Am Mittwoch, 7. November 2007 schrieb Heikki Linnakangas: > 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?
The "1" is substituted from somewhere else. If the value happens to be, say, 1.5, it works, but not with 1 or 2. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate