[GENERAL] plpgsql test function

[kurt miller]

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