Re: 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(at)Yahoo(dot)com #