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.
