Can I JOIN the table on the basis of the case statement in PostgreSQL. I have written the one SQL in stored procedure into that I'm passing the one flag on that basis I want to jon the table. Please see the case statement,

JOIN lease_intervals li_active
    ON ( li_active.cid = l.cid AND l.id = li_active.lease_id AND
         l.active_lease_interval_id = li_active.id )
LEFT JOIN applications a
    ON ( a.cid = li.cid AND li.lease_id = a.lease_id AND
         a.lease_interval_id = li.id )
 **CASE
            WHEN pIsFromUI = TRUE
                       THEN JOIN property_integration_databases pid ON ( pid.cid = l.cid AND pid.property_id == l.property_id )
               JOIN integration_databases id ON ( id.id = pid.integration_database_id AND id.cid = pid.cid )
       ELSE
           1
END**

Please let me know is there any alternate solution for above.