I'm missing something in the docs - how can I write a function
that returns multiple rows? I want to do the equivalent of:
select name from user_category where id = 21;
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?
Thanks,
Kief