Re: create function syntax error
| От | Shoaib Mir |
|---|---|
| Тема | Re: create function syntax error |
| Дата | |
| Msg-id | bf54be870607291343w397419fcw72677eb3c71c98f3@mail.gmail.com обсуждение исходный текст |
| Ответ на | create function syntax error (gustavo halperin <ggh.develop@gmail.com>) |
| Список | pgsql-general |
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)
--
Shoaib Mir
EnterpriseDB ( www.enterprisedb.com)
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.develop@gmail.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)
В списке pgsql-general по дате отправления: