plpgsql test function

kurt miller wrote:

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?

All I can see is a missing whitespace after "myval".
The PL/pgSQL parser isn't that smart as the main one.

Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #