From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
---|---|
To: | Pam Withnall <Pamw(at)zoom(dot)com(dot)au> |
Cc: | "'pgsql-hackers(at)postgresql(dot)org'" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: create function |
Date: | 2000-11-02 02:53:25 |
Message-ID: | Pine.BSF.4.10.10011011851350.72957-100000@megazone23.bigpanda.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
What version are you using? On a 7.0.2 freebsd machine,
I cut and paste the below function and query and had
no problems.
Stephan Szabo
sszabo(at)bigpanda(dot)com
On Thu, 2 Nov 2000, Pam Withnall wrote:
> 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?
>
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2000-11-02 03:26:50 | Re: Re: [GENERAL] 7.0 vs. 7.1 (was: latest version?) |
Previous Message | Pam Withnall | 2000-11-02 02:46:08 | create function |