select cs_group_max(Close,Day/3) from Quote_get('IBM'); cs_group_max ------------------------- float4:{20.2,40.2,50.5} (1 row) select cs_group_min(Close,Day/3) from Quote_get('IBM'); cs_group_min ------------------------- float4:{10.5,30.2,50.5} (1 row) select cs_group_sum(Close,Day/3) from Quote_get('IBM'); cs_group_sum ------------------------------------------------- float8:{30.7000007629395,70.4000015258789,50.5} (1 row) select cs_group_avg(Close,Day/3) from Quote_get('IBM'); cs_group_avg ------------------------------------------------- float8:{15.3500003814697,35.2000007629395,50.5} (1 row) select cs_group_var(Close,Day/3) from Quote_get('IBM'); cs_group_var -------------------------------- float8:{23.5225037002565,25,0} (1 row) select cs_group_dev(Close,Day/3) from Quote_get('IBM'); cs_group_dev ------------------------------- float8:{4.85000038146973,5,0} (1 row) select cs_group_first(Close,Day/3) from Quote_get('IBM'); cs_group_first ------------------------- float4:{10.5,30.2,50.5} (1 row) select cs_group_last(Close,Day/3) from Quote_get('IBM'); cs_group_last ------------------------- float4:{20.2,40.2,50.5} (1 row) select cs_group_all('int8:{3,1,6,7,0,3,6,5,2,3,7}','int4:{1,1,1,2,2,3,3,4,5,5,5}'); cs_group_all ------------------ int8:{0,0,2,5,2} (1 row) select cs_group_any('int2:{3,1,6,7,0,3,6,5,2,3,7}','char:{1,1,1,2,2,3,3,4,5,5,5}'); cs_group_any ------------------ int2:{7,7,7,5,7} (1 row)