User-Agent: Microsoft-Entourage/12.12.0.080729
Date: Wed, 27 Aug 2008 17:31:57 -0600
Subject: Re: FW: Libpq and the SQL RETURNING clause
From: Keary Suska <hierophant@pcisys.net>
To: Postgres-Interfaces <pgsql-interfaces@postgresql.org>
Message-ID: <C4DB400D.2870F%hierophant@pcisys.net>
Thread-Topic: [INTERFACES] FW: Libpq and the SQL RETURNING clause
Thread-Index: AckHeQiCaBeMR5FJQrKjwewrES+tvgA2BqmwABL9U7M=
In-Reply-To: <AC1B5B770E3FD54A94DED61FA96B12C3C9F196@CLPW44.f2.enterprise>
Mime-version: 1.0
Content-type: text/plain;
	charset="US-ASCII"
Content-transfer-encoding: 7bit

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"