Re: Trouble with PL/pgSQL

On Tue, 3 Apr 2001, Kevin Willems wrote:

> I wrote the following test function:
> 
> CREATE FUNCTION tester(text)
> RETURNS text
> AS 'DECLARE
>    str text;
> BEGIN
>    str := upper($1);
>    RETURN str;
> END;'
> LANGUAGE'plpgsql'
> 
> This runs OK. However, when I go to use it as follows:
> 
> SELECT tester('sometext');
> 
> I get the error:
> 
> NOTICE: plpgsql: ERROR during compile of tester near line 1
> "RROR: parse error at or near "

If this is the actual function you used, then you need a space between
LANGUAGE and 'plpgsql';

-- 
Joel Burton   
Director of Information Systems, Support Center of Washington