Re: [GENERAL] Does PG support bulk operation in embedded C

2015-05-19 Thread Joshua D. Drake 


On 05/19/2015 04:47 PM, Ravi Krishna wrote:


To explain pls refer to this for DB2

http://www-01.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.luw.apdv.cli.doc/doc/r0002329.html


Essentially in one single sql call, we can do
-- Add new rows
-- Update a set of rows where each row is identified by a bookmark
-- Delete a set of rows where each row is identified by a bookmark
-- Fetch a set of rows where each row is identified by a bookmark

This gives tremendous performance benefits as the network round trip is
avoided for each sql.

I am looking for an equivalent of this in PG and C language.


For embedded C, I believe you are looking for:

http://www.postgresql.org/docs/9.4/static/ecpg.html




Thanks.






--
Command Prompt, Inc. - http://www.commandprompt.com/  503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Announcing I'm offended is basically telling the world you can't
control your own emotions, so everyone else should do it for you.


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Does PG support bulk operation in embedded C

2015-05-19 Thread Michael Paquier 
On Wed, May 20, 2015 at 8:47 AM, Ravi Krishna srkris...@gmx.com wrote:
 Essentially in one single sql call, we can do
 -- Add new rows
 -- Update a set of rows where each row is identified by a bookmark
 -- Delete a set of rows where each row is identified by a bookmark
 -- Fetch a set of rows where each row is identified by a bookmark

 This gives tremendous performance benefits as the network round trip is
 avoided for each sql.

 I am looking for an equivalent of this in PG and C language.

What you are looking at could be accomplished with a user-defined function:
http://www.postgresql.org/docs/devel/static/xfunc.html
Perhaps you are looking for something in C, now it would be less
complex to do it for example with pl/pgsql or another language, and
call it from a C client with a correct set of arguments satisfying
your needs.
-- 
Michael


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general