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
