Pass where clause to a function - Mailing list pgsql-general

From Andrew Bartley
Subject Pass where clause to a function
Date
Msg-id CAA3RN+wQQijWyNND3B5Az2HNpSCv8ZsC3eBA5nt19TDbptNRGA@mail.gmail.com
Whole thread Raw
Responses Re: Pass where clause to a function  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
Hi all,

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....

Thanks


pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: Trigger function cannot reference field name with capital letter
Next
From: John R Pierce
Date:
Subject: Re: Pass where clause to a function