Re: Pass where clause to a function

On 8/13/2014 10:08 PM, Andrew Bartley wrote:
>
> Is it possible to create a view or foreign table that will do
> something like this
>
> select * from table_x
> where x_id = 10;
>
> passing the where "x_id = 10" to a function
>
> sorta like this
>
> select * from api_function('x = 10')
>
> or
>
> select * from api_function(10)
>
> passing the result set back to the original select....
>

your first version of api_function would have to use that x=10 to
construct the query and EXECUTE it, then return the recordset,

your second version of the view would just pass 10 in as an argument,
which could be used for the query select * from table_x where x_id=$1

either way, your view would be select * from api_function(whichever).

but I think you're rather confused here, as I don't see much utility in
either of these constructs in the form you specified.

--
john r pierce 37N 122W
somewhere on the middle of the left coast