On Wed, Sep 14, 2016 at 2:00 AM, Mat Arye wrote:
> I am leaning towards solution 3 for now. But it's kind of a hack. Is there
> any better solution that I am missing?
>
You probably will want to look into using/returning a cursor - though I'm
not that familiar with them myself.
David J.
Hi All,
I have a project where I wrote custom plpgsql functions to do specialized
queries of my dataset. These functions dynamically generate sql and then
RETURN EXECUTE that generated sql. From the client perspective the usage
looks like:
SELECT * FROM exec_query(new_query_object(param1 => 'blah