主页 / dba / 问题 / 280272
Accepted
vikrant rana
Asked: 2020-11-25 12:52:35 +0800 CST

在 PostgreSQL 中使用 ANY 从多个值中选择

  • 772

我在 Postgres 表上运行如下查询：

      Column      |            Type             |     Modifiers
------------------+-----------------------------+--------------------
 status           | character varying(16)  

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

这似乎工作正常，但低于

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

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

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

ANY还建议使用或在性能上是否有任何差异IN

postgresql

1 个回答

  1. Best Answer

    不，没有区别

    CREATE TABLE incoming_requests ("status" character varying(16) )

    ✓

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

    ✓

    db<>在这里摆弄

    • 1

相关问题