[GENERAL] conditional joins and views

2007-04-24 Thread Jonathan Vanasco
Is it possible at all to use conditional joins in views? ie: select a.* , b.* from a inner join b ON ( (a.id = b.id) AND (a.otherfield ?) ) I have a few 15-20 table joins that i'd like to push into views. i've never wanted to push something with a conditional join into a view before,

Re: [GENERAL] conditional joins and views

2007-04-24 Thread Peter Eisentraut
Am Dienstag, 24. April 2007 21:43 schrieb Jonathan Vanasco: Is it possible at all to use conditional joins in views? ie: select a.* , b.* from a inner join b ON ( (a.id = b.id) AND (a.otherfield ?) ) I have a few 15-20 table joins that i'd like to push into views. i've never wanted