Problem with function invocation

From: DaVinci <bombadil(at)wanadoo(dot)es>
To: Lista PostgreSql <pgsql-general(at)postgresql(dot)org>
Subject: Problem with function invocation
Date: 2001-04-16 13:43:23
Message-ID: 20010416154323.A15808@fangorn.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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';

And try to invoque with:

# select pilpot();

I get next error:

ERROR: parser: parse error at or near "("

Where is the problem with this?

Thanks a lot.

David

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tulio Oliveira 2001-04-16 14:01:40 Driver ODBC postdrv.exe fails on 7.1
Previous Message Preeti Kamble 2001-04-16 13:36:59 Cursors in plpgsql