Function return rows? - Mailing list pgsql-sql

From Pat M
Subject Function return rows?
Date
Msg-id 9p4s81$19q9$1@news.tht.net
Whole thread Raw
List pgsql-sql
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.






pgsql-sql by date:

Previous
From: Joel Mc Graw
Date:
Subject: 7.0.3 and 7.1.3 different results?
Next
From: bpalmer
Date:
Subject: faster and faster!!