generate a histogram of bin counts of a column given the min and max of the column and the number of bins.

histogram.sql

  CREATE OR REPLACE FUNCTION hist_sfunc (state INTEGER[], val REAL, min REAL, max REAL, nbuckets INTEGER) RETURNS INTEGER[] AS $$
  DECLARE
    bucket INTEGER;
    i INTEGER;
  BEGIN
    bucket := width_bucket(val, min, max, nbuckets - 1) - 1;
   
    IF state[0] IS NULL THEN
      FOR i IN SELECT * FROM generate_series(0, nbuckets - 1) LOOP
        state[i] := 0;
      END LOOP;
    END IF;
   
    state[bucket] = state[bucket] + 1;
   
    RETURN state;
  END;
  $$ LANGUAGE plpgsql IMMUTABLE;