skip to content
Skill Issue Dev | Dax the Dev
search
← all notes

TIL: Postgres has a real BIT(n) type

Today I learned Postgres ships with a first-class BIT(n) and BIT VARYING(n) type — not a bytea, not an int you bit-twiddle yourself. You can &, |, ~, and << directly in SQL.

Useful for feature flag bitsets where you want index-friendly equality on the bag, but still want & mask = mask server-side.