select cs_hash_max(Close,Day % 2) from Quote_get('IBM');
             cs_hash_max             
-------------------------------------
 ("float4:{50.5,40.2}","int4:{0,1}")
(1 row)

select cs_hash_min(Close,Day % 2) from Quote_get('IBM');
             cs_hash_min             
-------------------------------------
 ("float4:{20.2,10.5}","int4:{0,1}")
(1 row)

select cs_hash_sum(Close,Day % 2) from Quote_get('IBM');
                         cs_hash_sum                         
-------------------------------------------------------------
 ("float8:{100.900001525879,50.7000007629395}","int4:{0,1}")
(1 row)

select cs_hash_avg(Close,Day % 2) from Quote_get('IBM');
                         cs_hash_avg                         
-------------------------------------------------------------
 ("float8:{33.6333338419596,25.3500003814697}","int4:{0,1}")
(1 row)

select (q.p).agg_val,cs_cut((q.p).group_by,'i4i4') from (select cs_project_agg(cs_hash_sum(Close,(Day % 2)||(Volume%10))) p from Quote_get('IBM')) q;
     agg_val      | cs_cut 
------------------+--------
 50.7000007629395 | (1,0)
 100.900001525879 | (0,0)
(2 rows)

select p.agg_val,cs_cut(p.group_by,'i4i4') from (select (cs_project_agg(cs_hash_sum(Close,(Day % 2)||(Volume%10)))).* from Quote_get('IBM')) p;
     agg_val      | cs_cut 
------------------+--------
 50.7000007629395 | (1,0)
 100.900001525879 | (0,0)
(2 rows)

create type PairOfInt as (first integer, second integer);
select p.agg_val,cs_as(p.group_by,'PairOfInt') from (select (cs_project_agg(cs_hash_sum(Close,(Day % 2)||(Volume%10)))).* from Quote_get('IBM')) p;
     agg_val      | cs_as 
------------------+-------
 50.7000007629395 | (1,0)
 100.900001525879 | (0,0)
(2 rows)

select cs_hash_count(cs_floor((High-Low)*10)) from Quote_get('IBM');
         cs_hash_count          
--------------------------------
 ("int8:{4,1}","float8:{10,0}")
(1 row)

select cs_hash_dup_count(cs_ceil((High-Low)*10), Day%3) from Quote_get('IBM');
        cs_hash_dup_count        
---------------------------------
 ("int8:{1,1,2}","int4:{1,0,2}")
(1 row)

select cs_hash_all('int4:{3,1,6,7,0,3,6,5,2,3,7}','int8:{1,1,1,2,2,3,3,4,5,5,5}');
               cs_hash_all               
-----------------------------------------
 ("int4:{0,2,5,0,2}","int8:{1,5,4,2,3}")
(1 row)

select cs_hash_any('char:{3,1,6,7,0,3,6,5,2,3,7}','int2:{1,1,1,2,2,3,3,4,5,5,5}');
               cs_hash_any               
-----------------------------------------
 ("char:{7,7,7,5,7}","int2:{2,1,5,4,3}")
(1 row)

select cs_code2str(group_by, 1) as country, cs_code2str(group_by, 2) as device, agg_val as counter from (select (cs_project_agg(cs_hash_count(country||device))).* from CrashLog_get()) s;
 country |     device     | counter 
---------+----------------+---------
 Japan   | Sony Xperia Z1 |       1
 USA     | iPhone4        |       1
 China   | iPhone5        |       1
(3 rows)