On Mon, May 15, 2017 at 10:02 AM, Nick Dro <postgresql(at)walla(dot)co(dot)il> wrote:
> Hi,
> I'm new to postgresql and couldn't find answer to this situation anywhere.
> I asked this here:
> http://stackoverflow.com/questions/43984208/coditional-
> join-of-query-using-postgresql
>
> I hope there is a better solution rather than creating two separated
> functions :(
>
Generate the SQL itself in a string then execute the string. Its called
"Dynamic SQL".
https://www.postgresql.org/docs/9.6/static/plpgsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN
David J.