From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
---|---|
To: | anand086 <anand086(at)gmail(dot)com> |
Cc: | "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: Using bind variable within BEGIN END |
Date: | 2017-06-02 18:21:40 |
Message-ID: | CAKFQuwbFbv9FRJ_Ghb0f6ZhYtPaXzFaFzh3PWhigBtrBSc4_kA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
On Friday, June 2, 2017, anand086 <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"
> + "
> p_entity_type => ?, \n"
> + "
> p_attribute_name => ?, \n"
> + "
> p_creator_id => ?, \n"
> + "
> p_description => ? \n"
> + " );"
> + "end;",
> systemName,
> entityType,
>
> attributeName,
> creatorID,
>
> attributeDescription);
>
>
> access.register_type is a function
>
>
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.
David J.
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2017-06-02 18:27:12 | Re: Using bind variable within BEGIN END |
Previous Message | anand086 | 2017-06-02 17:29:22 | Re: Using bind variable within BEGIN END |