[SQL] Error with functions

[shyamperi]

Hey,
create or replace function sample(varchar,int) returns varchar as'
declare
        data alias for $1;
        size alias for $2;
begin
        return  substr(data,(length(data)-size)+1,length(data));
end;
' language 'plpgsql';
____________________________
WARNING:  plpgsql: ERROR during compile of sample near line 2
ERROR:  parse error at or near ";"

Can any body tell me why is this error coming
-----
Warm Regards
Shÿam Peri

II Floor, Punja Building,
M.G.Road,
Ballalbagh,
Mangalore-575003 
Ph : 91-824-2451001/5
Fax : 91-824-2451050 


DISCLAIMER: This message contains privileged and confidential information and is
intended only for the individual named.If you are not the intended
recipient you should not disseminate,distribute,store,print, copy or
deliver this message.Please notify the sender immediately by e-mail if
you have received this e-mail by mistake and delete this e-mail from
your system.

Hey, create or replace function sample(varchar,int) returns varchar as' declare         data alias for $1;         size alias for $2; begin         return  substr(data,(length(data)-size)+1,length(data)); end; ' language 'plpgsql'; ____________________________ WARNING:  plpgsql: ERROR during compile of sample near line 2 ERROR:  parse error at or near ";" Can any body tell me why is this error coming ----- Warm Regards Shÿam Peri II Floor, Punja Building, M.G.Road, Ballalbagh, Mangalore-575003 Ph : 91-824-2451001/5 Fax : 91-824-2451050 DISCLAIMER: This message contains privileged and confidential information and is intended only for the individual named.If you are not the intended recipient you should not disseminate,distribute,store,print, copy or deliver this message.Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system.

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend