Kief Morris writes:
> I create the following function:
>
> create function getid (int4) returns text as 'select name from mytable
> where id = $1;' language 'sql';
>
> ... but it only returns the first matching row. Is there
> a way to return all the matching rows?
No. Perhaps making a view would fit your application.
--
Peter Eisentraut Sernanders väg 10:115
peter_e(at)gmx(dot)net 75262 Uppsala
http://yi.org/peter-e/ Sweden