[Libpqxx-general] Calling "stored procedures" and capturing results

[Alex Milstead]

Hi all, 

I'm still fairly new to the pqxx library, but I must say I'm pretty impressed with it so far. At the very least, I'm glad I don't have to use the C (libpq) api anymore. What a pain! 

In any case, I've run into a bit of a problem recently and I can't seem to find much documentation and/or examples in the test/ folder that really address what I'm trying to do (maybe I've just missed it, entirely possible). 

I've created some PL/pgSQL functions on my db back-end, and I'd like to call them from the C++ app I'm writing to interface with it. Some of these functions return values, while others don't. I can call the functions just fine, but capturing the results is where I'm having the issue. 

How am I supposed to properly call the stored functions and subsequently capture their return values? 

Thanks in advance for any advice or suggestions. 

Cheers, 
Alex 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/libpqxx-general/attachments/20100118/d27875a3/attachment.html>