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
语句时,代码运行得很好。这里有什么问题?