You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
12 lines
425 B
12 lines
425 B
WITH data AS (
|
|
SELECT array_agg(x::numeric) s FROM generate_series(1,100) x
|
|
WHERE x % 5 != 0 AND x % 7 != 0
|
|
)
|
|
SELECT round(unnest(CDB_HeadsTailsBins(s, 7)),2) FROM data;
|
|
|
|
WITH data_nulls AS (
|
|
SELECT array_agg(CASE WHEN x % 2 != 0 THEN x ELSE NULL END::numeric) s FROM generate_series(1,100) x
|
|
WHERE x % 5 != 0 AND x % 7 != 0
|
|
)
|
|
SELECT round(unnest(CDB_HeadsTailsBins(s, 7)),2) FROM data_nulls;
|