Re: SETOF

Fernando <fernando@icreativa.com.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.