create function
Pam Withnall <pamw@zoom.com.au>
From: Pam Withnall <Pamw@zoom.com.au>
To: "'pgsql-hackers@postgresql.org'" <pgsql-hackers@postgresql.org>
Date: 2000-11-02T02:46:08Z
Lists: pgsql-hackers
I have installed plpgsql procedural language ok, I could not get any functions to work. I tried the most simple function as documented: CREATE FUNCTION sptest3 (int4) RETURNS int4 AS 'BEGIN RETURN $1+1; END;' LANGUAGE 'plpgsql'; When i call the function from sql SELECT sptest3(4) AS x; I get the error: "NOTICE: plpgsql: ERROR during compile of sptest3 near line 1 "RROR: parse error at or near " can anybody help?