[HACKERS] [7.3.x] function does not exist ... ?

2003-11-10 Thread Marc G. Fournier
'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:

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

2003-11-10 Thread Gaetano Mendola
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;

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

2003-11-10 Thread Andrew Dunstan
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

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

2003-11-10 Thread Marc G. Fournier
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