Hello,

I am wondering if the following scenario is possible.

std::string query("INSERT INTO MYTABLE (ID, JUNK) VALUES (DEFAULT, :sometext) 
RETURNING ID")
std::string sometext("some text");
int id(0);

statement st = sql.prepare << query, use(sometext, "sometext"), into(id);

MYTABLE.ID is a primary key that is generated by a sequence. I'm using 
postgresql as the backend, and I would rather not query the sequence for its 
currval in a separate step.  Is it possible to both insert and return a value 
from a query with SOCI as I'm trying to do?

Thanks,

Howard
------------------------------------------------------------------------------
How fast is your code?
3 out of 4 devs don\\\'t know how their code performs in production.
Find out how slow your code is with AppDynamics Lite.
http://ad.doubleclick.net/clk;262219672;13503038;z?
http://info.appdynamics.com/FreeJavaPerformanceDownload.html
_______________________________________________
Soci-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/soci-users

Reply via email to