Re: [GENERAL] Understanding setof

2014-04-04 Thread Jeff Janes
On Fri, Apr 4, 2014 at 12:42 PM, Robert James wrote: > I'm having trouble with setof returning functions > > Let's say I have function x() returning setof integers. I want to do > SELECT x(), but only keep the values which meet a criteria. Something > like: SELECT x() as xval WHERE xval = 10. >

Re: [GENERAL] Understanding setof

2014-04-04 Thread Raymond O'Donnell
On 04/04/2014 20:42, Robert James wrote: > I'm having trouble with setof returning functions > > Let's say I have function x() returning setof integers. I want to do > SELECT x(), but only keep the values which meet a criteria. Something > like: SELECT x() as xval WHERE xval = 10. > > How can I

[GENERAL] Understanding setof

2014-04-04 Thread Robert James
I'm having trouble with setof returning functions Let's say I have function x() returning setof integers. I want to do SELECT x(), but only keep the values which meet a criteria. Something like: SELECT x() as xval WHERE xval = 10. How can I do that? In general, is there a way to "unroll" a set