Pat M wrote: > Can I use a function to execute a query and return a row or set of rows?
No. Consider using temporary tables if you must do this. > 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. ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
