Dennis writes:
> Hi, I am having bad luck with a query that should return zero rows but
> actually never returns (completes execution.)
Seems like you need a multicolumn index on t_week_f, and maybe also on
nb_products, so that the conditions shown as "filters" here could be
applied as index con
Oh ya…
select fact.store_tag,fact.period,fact.upc upcid,
case when mkt_tag = 4480 then market.description else '' end retailmarket,
case when mkt_tag = 100 then market.description else '' end compmarket,
case when mkt_tag = 4480 then dollars else 0 end base_dollars,
case when mkt_tag = 100 then do
On 08/27/2014 11:02 AM, Dennis wrote:
Hi, I am having bad luck with a query that should return zero rows but
actually never returns (completes execution.)
And the query is :) ?
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
