"Roy's Email" <rmw256(at)hotmail(dot)com> writes:
> Using libpq, how do I get the return value from an INSERT statement?
> CREATE TABLE foo ( pk SERIAL , val text, PRIMARY KEY (pk) );
> INSERT INTO foo VALUES ( DEFAULT, 'stuff' ) RETURNING (pk);
> How do I get the value assigned to 'pk'? I assume it's in the 'PGresult' returned from 'PQexec()', but I can't find anything in the documentation for 'PGresult' that appears to discuss this particular use.
The PGresult is exactly the same as if you'd done "SELECT pk FROM ..."
regards, tom lane