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
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
