dates in functions

From: Salvador Mainé <salvamaine(at)yahoo(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: dates in functions
Date: 2001-03-02 14:50:32
Message-ID: 3A9FB338.A5A174C9@yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Why doesn't date_part work with pl/sql functions?

Thanks

--
Salvador Maine
http://www.ronincoders.com

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Salvador Mainé 2001-03-02 14:57:11 Re: dates in functions
Previous Message Sondaar Roelof 2001-03-02 14:09:32 RE: Help creating rules/triggers/functions