[ADMIN] create function problem

[Thomas Leung]

I want to index my table using the year of the date. So I create the 
following function.

create function to_year(date) returns varchar as '
declare
 str varchar;
 begin
   str := to_char($1, "YYYY");
   return str;
 end;
' language 'plpgsql' with (iscachable, isstrict);
But I face the problem as follow
select to_year(current_date);
WARNING:  Error occurred while executing PL/pgSQL functions to_year
WARNING:  line 4 at assignment
ERROR:  Attribute "YYYY" not found
Anybody can help? Thanks.

_________________________________________________________________
Linguaphone :  Learning English? Get Japanese lessons for FREE 
http://go.msnserver.com/HK/30476.asp

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
     joining column's datatypes do not match