Tableaux, plages et types composites

CREATE TABLE articles (id bigint PRIMARY KEY, tags text[] NOT NULL DEFAULT '{}');

SELECT * FROM articles WHERE tags @> ARRAY['postgres'];       -- contient
SELECT * FROM articles WHERE 'sql' = ANY (tags);              -- l'un des éléments
SELECT unnest(tags) AS tag, count(*) FROM articles GROUP BY 1;

SELECT '[2026-09-01, 2026-10-01)'::daterange @> date '2026-09-24';   -- true
SELECT tstzrange(now(), now() + interval '2 hours')
    && tstzrange(now() + interval '1 hour', now() + interval '3 hours');   -- chevauchement : true