[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