Re: create function syntax error
От | Andreas Kretschmer |
---|---|
Тема | Re: create function syntax error |
Дата | |
Msg-id | 20060730053425.GA5617@KanotixBox обсуждение исходный текст |
Ответ на | Re: create function syntax error (Andreas Kretschmer <akretschmer@spamfence.net>) |
Список | pgsql-general |
Andreas Kretschmer <akretschmer@spamfence.net> schrieb: > 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 Uhm, sorry. Error from me. The single quote after the 'as' is oray. 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 по дате отправления: