FW: Libpq and the SQL RETURNING clause

________________________________

From: Brefort, Georges R&D/FR
Sent: Tuesday, August 26, 2008 2:41 PM
To: pgsql-interfaces(at)postgresql(dot)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