This simple test function fails.
----------------------------------------------
drop function testit(text);
create function testit(text) returns text as '
DECLARE
myval text;
BEGIN
myval:= $1;
return myval;
END;
' language 'plpgsql';
select testit('testing');
select testit(''testing'');
----------------------------------------------
Result:
DROP
CREATE
ERROR: parser: parse error at or near ""
ERROR: parser: parse error at or near "testing"
It doesn't seem like the parameter passing mechanism is working.
What am i missing?
TIA,
-km
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com