Understanding setof - Mailing list pgsql-general

From Robert James
Subject Understanding setof
Date
Msg-id CAGYyBghUoqXwf8WdA=ToZtsNAaw-N_DeFwPuGFb7VnuptbZokw@mail.gmail.com
Whole thread Raw
Responses Re: Understanding setof
Re: Understanding setof
List pgsql-general
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 setof into a regular query?


pgsql-general by date:

Previous
From: David Rees
Date:
Subject: Re: SSD Drives
Next
From: Scott Marlowe
Date:
Subject: Re: SSD Drives