create function problem
| От | Thomas Leung |
|---|---|
| Тема | create function problem |
| Дата | |
| Msg-id | BAY8-F86Mma0n7J95K700001d87@hotmail.com обсуждение исходный текст |
| Ответы |
Re: create function problem
Re: create function problem |
| Список | pgsql-admin |
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
В списке pgsql-admin по дате отправления: