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
Really? I got no error and select sample('nothing',3) gave mi 'ing' What is your postgresql version?
Regards, Tomasz Myrta
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
