2024-04-09から1日間の記事一覧

postgres tag 配列

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 Bl…