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 zo

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 q

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; The

[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: a