From: | gulsumramazanoglu <gulsumramazanoglu(at)gmail(dot)com> |
---|---|
To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, anand086 <anand086(at)gmail(dot)com> |
Cc: | "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org> |
Subject: | YNT: Re: Using bind variable within BEGIN END |
Date: | 2017-06-02 18:38:14 |
Message-ID: | kdf2tkyatlx830fud5f1g71u.1496428694928@email.android.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
... which will pass arguments and get back a result set, i mean..
Samsung cihazımdan gönderildi
-------- Orjinal mesaj --------
Kimden: "David G. Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Tarih: 2 06 2017 9:21 PM (GMT+02:00)
Alıcı: anand086 <anand086(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Konu: Re: [SQL] Using bind variable within BEGIN END
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:57:31 | Re: Using bind variable within BEGIN END |
Previous Message | gulsumramazanoglu | 2017-06-02 18:35:42 | YNT: Re: Using bind variable within BEGIN END |