Tom Lane <[EMAIL PROTECTED]> writes: > * When we have a non-nullable expression in a sub-select's targetlist, > and it's below an outer join, replace the expression by > CASE WHEN flag_var THEN original_expression ELSE NULL END > and then flatten as normal.
I don't understand how this gets you any further ahead. Doesn't it just move the problems you have now with the original_expression to flag_var instead? -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's On-Demand Production Tuning -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers