Re: [SQL] Using bind variable within BEGIN END
| От | David G. Johnston |
|---|---|
| Тема | Re: [SQL] Using bind variable within BEGIN END |
| Дата | |
| Msg-id | CAKFQuwamhkBc+4dfNEZriefPKWEZTqgyEK2fe3y2T2xodzKzww@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: [SQL] Using bind variable within BEGIN END ("David G. Johnston" <david.g.johnston@gmail.com>) |
| Список | pgsql-sql |
On Friday, June 2, 2017, David G. Johnston <david.g.johnston@gmail.com> wrote:
On Friday, June 2, 2017, anand086 <anand086@gmail.com> wrote:Another example where we are getting the same error is from the call of the
below code --
ctx.update(""
+ "begin \n"
+ "
access.register_type( \n"
+ "
p_entity_system => ?, \n"PostgreSQL doesn't alllow named arguments when calling functions and function calls must be part of a SQL statement: select func(?,?,?,?.?); this applied even to functions that do not return results. IOW, PostgreSQL doesn't have stored procedures.
Guess I should have re-read the docs.
Named arguments are a thing so the main problem is that you don't have a select before your function name. Though I would have expected a different error message...
David J.
В списке pgsql-sql по дате отправления: