pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Function return rows? 2+ messages / 2 participants [nested] [flat]
* Function return rows? @ 2001-09-29 16:17 Pat M <pmeloy@removethispart.home.com> 0 siblings, 1 reply; 2+ messages in thread From: Pat M @ 2001-09-29 16:17 UTC (permalink / raw) To: 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. ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Function return rows? @ 2001-10-04 20:33 Allan Engelhardt <allane@cybaea.com> parent: Pat M <pmeloy@removethispart.home.com> 0 siblings, 0 replies; 2+ messages in thread From: Allan Engelhardt @ 2001-10-04 20:33 UTC (permalink / raw) To: Pat M <pmeloy@removethispart.home.com> 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. ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2001-10-04 20:33 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2001-09-29 16:17 Function return rows? Pat M <pmeloy@removethispart.home.com> 2001-10-04 20:33 ` Allan Engelhardt <allane@cybaea.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox