Received: from ns.dsn.ro ([193.226.135.27]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f25GK3x02522 for ; Mon, 5 Mar 2001 11:20:03 -0500 (EST) (envelope-from george@dsn.ro) Received: from dsn.ro (IDENT:george@george.dsn.ro [193.226.135.19]) by ns.dsn.ro (8.10.2/8.10.2) with ESMTP id f25GFqj12731; Mon, 5 Mar 2001 18:16:00 +0200 Message-ID: <3AA3BB25.28A68D8E@dsn.ro> Date: Mon, 05 Mar 2001 18:13:25 +0200 From: George Moga Organization: DataSystems Srl Slobozia X-Mailer: Mozilla 4.75 [en] (X11; U; Linux 2.2.17-21mdk i686) X-Accept-Language: en MIME-Version: 1.0 To: salva@ronincoders.com, pgsql-sql@postgresql.org Subject: Re: dates in functions References: <3A9FB338.A5A174C9@yahoo.com> Content-Type: text/plain; charset=iso-8859-2 Content-Transfer-Encoding: 8bit X-Archive-Number: 200103/49 X-Sequence-Number: 1694 Salvador Mainé wrote: > Hello: > > I'm trying to define a function that, given a date, returns its month. > The definition is as follows: > > CREATE function anyo_hidro (date) returns int AS ' > BEGIN > RETURN date_part("month",$1); > END; > ' LANGUAGE 'plpgsql'; > > But when I do: > > select anyo_hidro('1-1-1999'); > > I get the following error: > > ERROR: Attribute 'month' not found Try, test=# CREATE function anyo_hidro (date) returns int AS ' BEGIN RETURN date_part(\'month\',$1::datetime); END; ' LANGUAGE 'plpgsql'; CREATE test=# select anyo_hidro('1-1-1999'); anyo_hidro ------------ 1 (1 row) I use: test=# select version(); version --------------------------------------------------------------- PostgreSQL 7.0.3 on i686-pc-linux-gnu, compiled by gcc 2.95.3 (1 row) test=# George Moga, Data Systems Srl