DECLARE
total1 float;
total2 float;
SELECT
SUM(CASE WHEN totals.valid = 0 THEN amount ELSE 0 END),
SUM(CASE WHEN totals.valid <> 0 THEN amount ELSE 0 END)
INTO total1, total2
FROM
totals;
在这里,Postgres通知我我的条件语法中有一个错误:
ERROR: 42601: syntax error at end of input
LINE 12: SUM(CASE WHEN totals.valid = 0 THEN amount ELSE 0 END),
^
CONTEXT: invalid type name "SUM(CASE WHEN totals.valid "
但当我删除INTO total1, total2
声明时,代码运行得非常好.这里有什么问题?