Re: Using bind variable within BEGIN END

On Friday, June 2, 2017, David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
wrote:

> On Friday, June 2, 2017, anand086 <anand086(at)gmail(dot)com
> <javascript:_e(%7B%7D,'cvml','anand086(at)gmail(dot)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.

https://www.postgresql.org/docs/10/static/sql-syntax-calling-funcs.html

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.