Stored procedure

["Alain Roger" <raf.news@xxxxxxxxx>]

Hi,

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