SELECT
COUNT (
DISTINCT CASE
WHEN T .trandt >= substr('20170930', 1, 6) || '01' THEN
member_cd
END
) recharg_ct_mon
FROM
cds.CDS_P_RECHARGE T;
报一个错误
ERROR: array value must start with "{" or dimension information
解决方式:SELECT
(substr('20170930', 1, 6) || '01')