Postgres Query Array Column with Array
As documented in the manual there are two ways to specify an array constant
On is to use the array[...] notation:
SELECT * 
FROM people 
WHERE codes &amp;&amp; array[5294,1933]::bigint[]

Alternatively use a string that uses {..}
SELECT * 
FROM people 
WHERE codes &amp;&amp; '{5294,1933}'::bigint[]

I prefer the first one, as that also doesn't have problems when the data type itself requires quoting e.g. for text arrays.