kurita1 https://blog.hatena.ne.jp/kurita1/ external storage 1 https://kurita1.hatenadiary.com/ The query to find the cats are "red", "brown" and "aloof" is also wonderfully simple. SELECT Count(*) FROM cats_array_text WHERE cat_tags @> ARRAY['red', 'brown', 'aloof'];Tags and Postgres Arrays, a Purrrfect Combination | Crunchy Data Blog 2023 @> 包含する ARRAY[1,4,3] @> ARRAY[3,1] t https://www.post… 190 <iframe src="https://hatenablog-parts.com/embed?url=https%3A%2F%2Fkurita1.hatenadiary.com%2Fentry%2F2024%2F04%2F09%2F170604" title="postgres tag 配列 - external storage 1" class="embed-card embed-blogcard" scrolling="no" frameborder="0" style="display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;"></iframe> Hatena Blog https://hatena.blog 2024-04-09 17:06:04 rich https://kurita1.hatenadiary.com/entry/2024/04/09/170604 1.0 100%