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@Yahoo.com #