Re: SETOF

Fernando <fernando(at)icreativa(dot)com(dot)mx> writes:
> I am using Postgresql version 7.2.2

> CREATE FUNCTION ejem1(varchar) RETURNS SETOF to varchar as'
> SELECT names from mi_tabla WHERE city = $1; '
> language ' SQL ';

It's difficult to do anything very useful with functions returning sets
in 7.2. Update to 7.3 and try something like:
select * from ejem1('cityname');

regards, tom lane

PS: it's not really necessary to post the same question in three
different PG lists. Especially not one at a time.