Re: how to return more than 1 arg with a function ?

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