BEGIN;
-- isagg int should skip null keys;
-- ./spec/istore/aggregates_spec.rb:9;
CREATE EXTENSION istore;
SELECT id, isagg(NULLIF(i%10,3), NULLIF(i::int, 50) ) FROM generate_series(1,100) i, generate_series(1,3) id GROUP BY id ORDER BY id;;
 id |                                                   isagg                                                    
----+------------------------------------------------------------------------------------------------------------
  1 | "0"=>"500", "1"=>"460", "2"=>"470", "4"=>"490", "5"=>"500", "6"=>"510", "7"=>"520", "8"=>"530", "9"=>"540"
  2 | "0"=>"500", "1"=>"460", "2"=>"470", "4"=>"490", "5"=>"500", "6"=>"510", "7"=>"520", "8"=>"530", "9"=>"540"
  3 | "0"=>"500", "1"=>"460", "2"=>"470", "4"=>"490", "5"=>"500", "6"=>"510", "7"=>"520", "8"=>"530", "9"=>"540"
(3 rows)

ROLLBACK;
BEGIN;
-- isagg int should skip null values;
-- ./spec/istore/aggregates_spec.rb:16;
CREATE EXTENSION istore;
SELECT id, isagg((i%10), NULL::int) FROM generate_series(1,100) i, generate_series(1,3) id GROUP BY id ORDER BY id;;
 id | isagg 
----+-------
  1 | 
  2 | 
  3 | 
(3 rows)

ROLLBACK;
BEGIN;
-- isagg bigint should skip null keys;
-- ./spec/istore/aggregates_spec.rb:9;
CREATE EXTENSION istore;
SELECT id, isagg(NULLIF(i%10,3), NULLIF(i::bigint, 50) ) FROM generate_series(1,100) i, generate_series(1,3) id GROUP BY id ORDER BY id;;
 id |                                                   isagg                                                    
----+------------------------------------------------------------------------------------------------------------
  1 | "0"=>"500", "1"=>"460", "2"=>"470", "4"=>"490", "5"=>"500", "6"=>"510", "7"=>"520", "8"=>"530", "9"=>"540"
  2 | "0"=>"500", "1"=>"460", "2"=>"470", "4"=>"490", "5"=>"500", "6"=>"510", "7"=>"520", "8"=>"530", "9"=>"540"
  3 | "0"=>"500", "1"=>"460", "2"=>"470", "4"=>"490", "5"=>"500", "6"=>"510", "7"=>"520", "8"=>"530", "9"=>"540"
(3 rows)

ROLLBACK;
BEGIN;
-- isagg bigint should skip null values;
-- ./spec/istore/aggregates_spec.rb:16;
CREATE EXTENSION istore;
SELECT id, isagg((i%10), NULL::bigint) FROM generate_series(1,100) i, generate_series(1,3) id GROUP BY id ORDER BY id;;
 id | isagg 
----+-------
  1 | 
  2 | 
  3 | 
(3 rows)

ROLLBACK;