On Mon, May 15, 2017 at 10:02 AM, Nick Dro <postgre...@walla.co.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.
