使用Postpresql创建存储过程的时候报一个错误 ERROR: array value must start with "{" or dimension information

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')