Andreas Kretschmer <[EMAIL PROTECTED]> schrieb:
> gustavo halperin <[EMAIL PROTECTED]> schrieb:
>
> > Hello
> >
> > I Always get "syntax error" for every function that I try to create, for
> > example:
> > mydb'>create or replace function f_sum () returns void as '
> > mydb'> select 2+2
You are missing the BEGIN and END section. Make your function like this:CREATE OR REPLACE FUNCTION f_sum() RETURNS void AS 'BEGIN select 2+2; END;' LANGUAGE plpgsql;Thanks,-- Shoaib Mir
EnterpriseDB (www.enterprisedb.com)On 7/30/06,
gustavo halperin <[EMAIL PROTECTED]> wrote:
HelloI Always get
gustavo halperin <[EMAIL PROTECTED]> schrieb:
> Hello
>
> I Always get "syntax error" for every function that I try to create, for
> example:
> mydb'>create or replace function f_sum () returns void as '
> mydb'> select 2+2;
> mydb'> ' LANGUAGE plpgsql;
> ERROR: syntax error at