[GENERAL][SQL] Functions with composite resutl-set - Mailing list pgsql-general

Hi all,

I've a function who retrieves multiple columns:

CREATE FUNCTION myfunc() RETURNS SETOF mytable
AS 'SELECT a,b,c FROM mytable;' LANGUAGE 'sql';

When I call it, I cannot retrieve all columns without
executing 3 times the function.

select myfunc() does not work

select a(myfunc()), b(myfunc()), c(myfunc()) works but executes 3
times the function.

I've tried
select *(mynfunc())
select all(myfunc())
select myfunc()::mytable
select myfunc()::mytable.*
...

But i've a syntax error on each of these.

Any help ? Thanks.

--
Herve LEFEBVRE




_________________________________________________________
DO YOU YAHOO!?
Get your free @yahoo.com address at http://mail.yahoo.com