Thread: FW: Libpq and the SQL RETURNING clause
From: Brefort, Georges R&D/FR
Sent: Tuesday, August 26, 2008 2:41 PM
To: pgsql-interfaces@postgresql.org
Subject: Libpq and the SQL RETURNING clause
Dear Postgres specialist,
1 Assume you have a table such as the following:
CREATE TABLE example( id SERIAL, someData VARCHAR(32) );
2 Now, you use a SQL statement to insert the data and get the the id value back:
INSERT INTO example( someData ) VALUES( 'BlaBlaBla' ) RETURNING id;
I wonder if it is possible to retrieve the value of the id field in an application using the C libpq library.
I pretty much understand how to bind data with the libpq, or how to retrieve result sets from a SELECT SQL statement, but not how to retrieve data from that RETURNING clause. (I have many years of practice of the RETURNING clause in the ORACLE C library, but that is not the point here).
Thank you very much for your help and your patience.
With my best regards.
Georges BREFORT
8/27/08 8:28 AM, also sprach Georges.Brefort@sanofi-aventis.com: > > > ________________________________ > > From: Brefort, Georges R&D/FR > Sent: Tuesday, August 26, 2008 2:41 PM > To: pgsql-interfaces@postgresql.org > Subject: Libpq and the SQL RETURNING clause > > > Dear Postgres specialist, > > 1 Assume you have a table such as the following: > > CREATE TABLE example( id SERIAL, someData VARCHAR(32) ); > > 2 Now, you use a SQL statement to insert the data and get the the id > value back: > > INSERT INTO example( someData ) VALUES( 'BlaBlaBla' ) RETURNING id; > > I wonder if it is possible to retrieve the value of the id field in an > application using the C libpq library. Yes. I do it all the time. Simply treat the result as if it was from a select statement. HTH, Keary Suska Esoteritech, Inc. "Demystifying technology for your home or business"