PostgreSQL 到 MSSQL 数组

Question

我正在尝试编写与此查询等效的 MSSQL:

(CASE WHEN (to_number((column1), '9') = ANY (ARRAY[(1)::numeric, (5)::numeric])) THEN 'Discontinued' WHEN (to_number((column1), '9') = ANY (ARRAY[(0)::numeric, (3)::numeric, (7)::numeric])) THEN 'Covered' ELSE 'Not Covered' END AS coverage_status,)

Answer 1

Postgres 中的数组使用一开始就过于复杂(更不用说没用了)。这应该有效:

CASE 
   WHEN cast(column1 as integer) in (1,5) THEN 'Discontinued' 
   WHEN cast(column1 as integer) in (0,3,7) THEN 'Covered' 
   ELSE 'Not Covered' 
END AS coverage_status