I have a stored procedure which returns a SETOF RECORD. so basically a partial rowtype from a table.
to execute the query in PHP, i must write : select * from myschema.sp_a_002('username') as result(Column1 varchar);
to get the result.
However, is there another to get the result without using 'as result(column1 varchar)' ? something like a simple "select * from storedprocedure(param);", for example :-)
thanks a lot,
-- Alain ------------------------------------ Windows XP SP2 PostgreSQL 8.1.4 Apache 2.0.58 PHP 5