=# EXPLAIN SELECT    group_code::text                          AS group_code,
-#           sku::text                                 AS sku,
-#           stktype_code::varchar(2)                  AS stktype_code,
-#           brn_code::text                            AS brn_code,
-#           SUM(overdue)::int4                        AS overdue,
-#           SUM(current)::int4                        AS current,
-#           SUM(future)::int4                         AS future
-# FROM (    
(# SELECT    group_code,
(#           sku,
(#           stktype_code,
(#           brn_code, 
(#           CASE WHEN to_date <= max_fpp_ms() THEN
(#              SUM(out_qty)
(#           ELSE  0                                      
(#           END                                     AS overdue,
(#           CASE WHEN to_date > max_fpp_ms()
(#           AND to_date <= max_fpp_me() THEN
(#              SUM(out_qty)
(#           ELSE 0
(#           END                                     AS current,
(#           CASE WHEN to_date > max_fpp_me() THEN
(#              SUM(out_qty)
(#           ELSE 0
(#           END                                     AS future
(# FROM gir_outstanding
(# GROUP BY  group_code,
(#           sku,
(#           stktype_code,
(#           brn_code,
(#           to_date
(# ) AS sub
-# GROUP BY  group_code, 
-#           sku,
-#           stktype_code,
-#           brn_code
-# ;
                                                   QUERY PLAN                                                    
-----------------------------------------------------------------------------------------------------------------
 Aggregate  (cost=15880.41..16055.62 rows=876 width=44)
   ->  Group  (cost=15880.41..15989.92 rows=8761 width=44)
         ->  Sort  (cost=15880.41..15902.31 rows=8761 width=44)
               Sort Key: group_code, sku, stktype_code, brn_code
               ->  Subquery Scan sub  (cost=13335.57..15306.72 rows=8761 width=44)
                     ->  Aggregate  (cost=13335.57..15306.72 rows=8761 width=44)
                           ->  Group  (cost=13335.57..14649.67 rows=87607 width=44)
                                 ->  Sort  (cost=13335.57..13554.58 rows=87607 width=44)
                                       Sort Key: group_code, sku, stktype_code, brn_code, to_date
                                       ->  Seq Scan on gir_outstanding  (cost=0.00..4687.07 rows=87607 width=44)
(10 rows)