if this column contains a text-value "RU"?
'RU' = ANY(column) – work for int[] only
UPD: Maybe there ru-chat?
are you trying to have a CONTAINS in the element, or an exact value? select 12 where 'RU' = ANY('{RU,AB,CD}'::text[]); — Works select 12 where 'RU' = ANY('{RU12,AB,CD}'::text[]); — Fails
Here is how I solve these problems... SELECT locations, ANY('RU',locations) from table LIMIT 1;
Обсуждают сегодня