Re: [GENERAL] execution plan is wrong, or the query ?

2012-12-13 Thread Alex Burkoff
Upgrade to 9.2.2 totally fixed the issue. Thanks again! From: Tom Lane [t...@sss.pgh.pa.us] Sent: Tuesday, December 11, 2012 9:10 AM To: Alex Burkoff Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] execution plan is wrong, or the query ? Alex

Re: [GENERAL] execution plan is wrong, or the query ?

2012-12-11 Thread Alex Burkoff
Understood. Thank you! From: Tom Lane [t...@sss.pgh.pa.us] Sent: Tuesday, December 11, 2012 9:10 AM To: Alex Burkoff Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] execution plan is wrong, or the query ? Alex Burkoff writes: > I think I am j

Re: [GENERAL] execution plan is wrong, or the query ?

2012-12-11 Thread Alex Burkoff
when CASE is used in the WHERE clause - straight text comparison does produce correct results. Thanks! From: Tom Lane [t...@sss.pgh.pa.us] Sent: Monday, December 10, 2012 6:09 PM To: Alex Burkoff Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL

[GENERAL] execution plan is wrong, or the query ?

2012-12-10 Thread Alex Burkoff
Folks, I have a following query that used to work as intended on 8.3.5 : SELECT COUNT(*) FROM jiveDeployRequest dr LEFT JOIN jiveDeployType dt ON dr.deployTypeId = dt.deployTypeId LEFT JOIN jiveDeployStatus ds ON dr.deployStatusId = ds.deployStatusId LEFT OUTER JOIN jiveCustomerInstallationDeplo