Re: [GENERAL] Dynamic query return

2016-09-14 Thread David G. Johnston
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. ​

[GENERAL] Dynamic query return

2016-09-14 Thread Mat Arye
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