Feite Brekeveld wrote: > > I want to return mre than 1 arg > > create function func(varchar) > --> returns var1, var2 .... > as ' > ... > ' > language 'sql'; > > How to deal with the return : The manual says to use SETOF can't figure > out how that works no examples are given. Not quite right. SETOF returns many items so you could have: create function list_ids() returns setof int4 as 'select id from foo;' language 'sql'; select list_ids(); list_id ------- 1 2 7 12 You can also return a tuple like: create function whole_row() returns foo as ... But - that can only be used to feed into another function, not in a "raw" select statement. HTH - Richard Huxton
