On Tue, June 13, 2006 00:21, Rilson Nascimento wrote: > 1) Function call. My initial attempt was to write something like this: > > result R( T.exec( "SELECT * from function(input1, input2) as (f1 > timestamp, f2 varchar, f3 char(10))" ) ); > > - Is that the best way to call a pl/pgsql function that returns > records with pqxx?
If it is in any interface to postgres, then it is also in libpqxx; libpqxx knows *nothing* about stored procedures. As far as libpqxx is concerned, you're just executing SQL and receiving results. Therefore: > - Do I really need to describe the anonymous record? since the result > set is not a table type, > is there another option besides CREATE TYPE? (I am using PgSQL 8.1) ...This question ends up completely unrelated to libpqxx, so you may get more useful information on a core PostgreSQL list, such as pgsql-interfaces, pgsql-general, or pgsql-sql. I think the latter is your best bet. The lists can be found here: http://www.postgresql.org/community/lists/ Jeroen _______________________________________________ Libpqxx-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/libpqxx-general
