Re: [7.3.x] function does not exist ... ?

On Mon, 10 Nov 2003, Gaetano Mendola wrote:

> Marc G. Fournier wrote:
>
> > 'k, this doesn't look right, but it could be that I'm overlooking
> > something ...
> >
> > The function I created:
> >
> > CREATE FUNCTION month_trunc (timestamp without time zone) RETURNS timestamp without time zone
> >     AS 'SELECT date_trunc(''month'', $1 )'
> >     LANGUAGE sql IMMUTABLE;
> >
> >
> > The query that fails:
> >
> > ams=# select * from traffic_logs where month_trunc(runtime) = month_trunc(now());
> > ERROR:  Function month_trunc(timestamp with time zone) does not exist
> >         Unable to identify a function that satisfies the given argument types
> >         You may need to add explicit typecasts
>
> now return a timestamp with time zone and your function
> take a timestamp without time zone.
>                   ^^^^^^^

d'oh, I knew I was mis-reading something there ... thanks