SET sql_safe_updates = false;

CREATE TABLE seed AS SELECT g AS _float8,
                            g * '1 day'::INTERVAL,
                            g % 2 = 1 AS _bool,
                            g::DECIMAL AS _decimal
                       FROM generate_series(1, 1) AS g;

INSERT INTO seed (_float8, _bool, _decimal) VALUES (0.9, true, 0);

UPDATE seed AS t SET _bool = t._bool AND false;

INSERT INTO seed (_bool, _decimal) VALUES (false, 1.0);

ANALYZE seed;

SHOW STATISTICS FOR TABLE seed;

SHOW HISTOGRAM <id>;