Re: [GENERAL] create function syntax error

2006-07-29 Thread Andreas Kretschmer
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

Re: [GENERAL] create function syntax error

2006-07-29 Thread Shoaib Mir
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

Re: [GENERAL] create function syntax error

2006-07-29 Thread Andreas Kretschmer
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