值在数组中:
SELECT COUNT(*) FROM "messages" WHERE 3 = ANY (recipient_ids)
值不在数组中
SELECT COUNT(*) FROM "messages" WHERE NOT (3 = ANY (recipient_ids))
如果你用的是 node.js 的 pg 包,值在数组中可以这样写:
var ids = [1,3,4];
var q = client.query('SELECT Id FROM MyTable WHERE Id = ANY($1::int[])',[ids]);
q.on('row', function(row) {
console.log(row);
})
// outputs: { id: 1 }
// { id: 3 }
// { id: 4 }