Re: Problem with function invocation - Mailing list pgsql-general

From Stephan Szabo
Subject Re: Problem with function invocation
Date
Msg-id Pine.BSF.4.21.0104160813410.71391-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Problem with function invocation  (DaVinci <bombadil@wanadoo.es>)
List pgsql-general
On Mon, 16 Apr 2001, DaVinci wrote:

>  Hello.
>
>  When I create next function:
>
>      create function pilpot() returns integer as '
>         declare
>             foo integer;
>         begin
>             foo = insert into aviso(user) values(1);
>             return foo;
>         end;
>     ' language 'plpgsql';
>

What exactly are you trying to return from the function?
Removing the foo declaration and foo = from the insert line
(and double quoting the reserved word user) on 7.1 makes
the function work for me (I just returned 1).


pgsql-general by date:

Previous
From: Justin Clift
Date:
Subject: Re: OS Crypt()
Next
From: Lamar Owen
Date:
Subject: RPMs for PostgreSQL7.1 available.