Re: create function syntax error

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 <ggh(dot)develop(at)gmail(dot)com> wrote:
>
> 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 or near "select" at character 56
> LINE 2: select 2+2;
> ^
>
> What its the problem ??
> Thank you,
> Gustavo
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>

--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)