{"version":"1.0","blog_title":"external storage 1","image_url":null,"author_name":"kurita1","provider_name":"Hatena Blog","blog_url":"https://kurita1.hatenadiary.com/","title":"postgres tag \u914d\u5217","provider_url":"https://hatena.blog","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fkurita1.hatenadiary.com%2Fentry%2F2024%2F04%2F09%2F170604\" title=\"postgres tag \u914d\u5217 - 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>","height":"190","type":"rich","width":"100%","author_url":"https://blog.hatena.ne.jp/kurita1/","url":"https://kurita1.hatenadiary.com/entry/2024/04/09/170604","published":"2024-04-09 17:06:04","description":"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 @> \u5305\u542b\u3059\u308b ARRAY[1,4,3] @> ARRAY[3,1] t https://www.post\u2026","categories":[]}