我有一列包含一個字串陣列。我嘗試選擇該列中包含特定單詞的專案，但出現此錯誤：
function contains(character varying[], unknown) does not exist
這是我的選擇查詢：
SELECT "schedule", COUNT("schedule") AS "count"
FROM "members" AS "member"
WHERE contains("member"."facility_id", 'DEMO')
GROUP BY "schedule";
uj5u.com熱心網友回復：
如果要測驗字串陣列是否包含特定元素，則需要使用 contains運算子，@>但僅適用于兩側的陣列
WHERE member.facility_id @> array['DEMO']
要測驗單個值，您還可以使用any運算子：
WHERE 'DEMO' = ANY(member.facility_id)
轉載請註明出處，本文鏈接：https://www.uj5u.com/caozuo/511357.html