Skip site navigation (1) Skip section navigation (2)

create function problem

From: "Thomas Leung" <thomasleung(at)hotmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: create function problem
Date: 2004-03-16 04:02:24
Message-ID: (view raw, whole thread or download thread mbox)
Lists: 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 '
  str varchar;
    str := to_char($1, "YYYY");
    return str;
' 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


pgsql-admin by date

Next:From: Erwin BrandstetterDate: 2004-03-16 08:43:34
Subject: Re: Hardware for a database server
Previous:From: Tom LaneDate: 2004-03-15 22:07:09
Subject: Re: nodeRead: did not find '}' at end of plan node

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group