ilovejs · April 12, 2018 00:39
diff --git a/histogram_in_pg.sql b/histogram_in_pg.sql
 SELECT
 	x,
 	WIDTH_BUCKET(x, 1, 10, 9) AS "x In Which Bucket ?"
 FROM
 	generate_series(1, 10) x;

 SELECT
 	ROW_NUMBER() OVER(),
 	*
 FROM
 	generate_series(1, 10) x;
	SELECT
	x,
	WIDTH_BUCKET(x, 1, 10, 9) AS "x In Which Bucket ?"
	FROM
	generate_series(1, 10) x;

	SELECT
	ROW_NUMBER() OVER(),
	*
	FROM
	generate_series(1, 10) x;