Trouble with PL/pgSQL

Поиск
Список
Период
Сортировка
Искать

Trouble with PL/pgSQL

От:
"Kevin Willems" <kdwillems@hotmail.com>
Дата:
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 "

Does anyone know why this is happening? Any help would really be
appreciated.

- Kevin Willems

Re: Trouble with PL/pgSQL

От:
Joel Burton <jburton@scw.org>
Дата:
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
FAQ