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