create function - Mailing list pgsql-hackers

From Pam Withnall
Subject create function
Date
Msg-id D10ACC8031A3FD47A7860D3590D6A1D1F594@zoom-ads.zoomnet.zoom.com.au
Whole thread Raw
Responses Re: create function
Re: create function
List 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?


pgsql-hackers by date:

Previous
From: Tatsuo Ishii
Date:
Subject: RE: WAL: postmaster won't start
Next
From: Stephan Szabo
Date:
Subject: Re: create function