By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE
INSERT 0 15
SELECT 6
INSERT 0 1
| user_id | products | shirt_before_pants |
|---|---|---|
| 1 | {hat,pants,socks} | f |
| 2 | {shirt,pants,socks} | t |
| 3 | {pants,shirt} | f |
| 4 | {socks,shirt,pants} | t |
| 5 | {hat,shirt} | f |
| 6 | {belt} | f |
SELECT 6