Can I use a function to execute a query and return a row or set of rows? If
so, can you point me to some examples or perhaps give me an example of a
function that would do roughly the same thing as:
select * from mytable where mytable.name ~* 'aname';
I can't seem to find any examples that return rows, just single ints and
bools and stuff.