select from mulitple values using ANY in PostgreSQL I am running a query on Postgres table as below:
      Column      |            Type             |     Modifiers
------------------+-----------------------------+--------------------
 status           | character varying(16)  

select FROM incoming_requests WHERE COALESCE(TRIM(status), '') IN ('','OK','ERROR');

This seems to working fine but below not
select FROM incoming_requests WHERE COALESCE(TRIM(status), '') = ANY ('','OK','ERROR');

ERROR:  syntax error at or near &quot;,&quot;
LINE 1: ...quests WHERE COALESCE(TRIM(status), '') = ANY (&quot; &quot;,&quot;OK&quot;,&quot;ERR...

select FROM incoming_requests WHERE COALESCE(TRIM(status), '') = ANY (&quot; &quot;,&quot;OK&quot;,&quot;ERROR&quot;);

Also suggest if there is any difference in performance using ANY or IN
No there is no difference


CREATE TABLE incoming_requests (&quot;status&quot; character varying(16) )


✓




select FROM incoming_requests WHERE COALESCE(TRIM(status), '') = ANY (array['', 'OK', 'ERROR']);


✓


db&lt;&gt;fiddle here