Re: create function syntax error
От | Andreas Kretschmer |
---|---|
Тема | Re: create function syntax error |
Дата | |
Msg-id | 20060729204230.GB16132@KanotixBox обсуждение исходный текст |
Ответ на | create function syntax error (gustavo halperin <ggh.develop@gmail.com>) |
Ответы |
Re: create function syntax error
|
Список | pgsql-general |
gustavo halperin <ggh.develop@gmail.com> 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 or near "select" at character 56 > LINE 2: select 2+2; > ^ > > What its the problem ?? Several: - wrong quotation, either with '' or with dollar-quote - no 'begin' - no 'end;' Please read the docu: http://www.postgresql.org/docs/8.1/interactive/plpgsql.html There are many examples, for instance: http://www.postgresql.org/docs/8.1/interactive/plpgsql-structure.html HTH, Andreas -- Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. (Linus Torvalds) "If I was god, I would recompile penguin with --enable-fly." (unknow) Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
В списке pgsql-general по дате отправления: