> On 15 May 2017, at 19:02, 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 :(
You can use your boolean parameter inside the join condition: […] on (tfquery.a = main.a and ((type_f and tfquery.d = main.d) or not type_f)) Beware that you don't also have a column named type_f in that join somewhere. Alban Hertroys -- If you can't see the forest for the trees, cut the trees and you'll find there is no forest. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
