postgresql - 错误 : INTO specified more than once at or near "INTO"

Question

在 postgresql 函数中，我试图将从表中选择的两个值放入两个变量中，但出现此错误:

INTO specified more than once at or near "INTO"

这是(伪)代码:

CREATE OR REPLACE FUNCTION func() RETURNS TRIGGER AS
$$ 
DECLARE
    a numeric;
    b varchar(20);
    c numeric;
BEGIN
    IF ... THEN
        ...

        SELECT x INTO a FROM t1 WHERE y = 1

        IF a > 5 THEN
            SELECT m, n INTO b, c FROM t2 WHERE ...;
            ...
        END IF;
    END IF;
END
$$ LANGUAGE plpgsql;

Answer 1

问题只是(一如既往)缺少分号。

只需在第一个 SELECT 语句中添加缺少的分号

[...]

    SELECT x INTO a FROM t1 WHERE y = 1; #missing semicolon

    IF a > 5 THEN
        SELECT m, n INTO b ...;
[...]

INTO specified more than once 错误是从第二个 SELECT 语句(当它找到第二个 INTO 时)生成的，但它没有没有太多关于在哪里可以找到问题的建议。