Database & utility Scalar

equi_width_bins()

Generates bin_count equi-width bins between the min and max. If enabled nice_rounding makes the numbers more readable/less jagged

Arguments & returns

4 overloads

Scalar

Overload link	`min`	`max`	`bin_count`	`nice_rounding`	Returns
#01	`ANY`	`ANY`	`BIGINT`	`BOOLEAN`	`ANY[]`
#02	`BIGINT`	`BIGINT`	`BIGINT`	`BOOLEAN`	`ANY[]`
#03	`DOUBLE`	`DOUBLE`	`BIGINT`	`BOOLEAN`	`ANY[]`
#04	`TIMESTAMP`	`TIMESTAMP`	`BIGINT`	`BOOLEAN`	`ANY[]`

SELECT equi_width_bins(0, 10, 2, true);

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.