在pl/pgsql中找不到pl/sql%的等价物是什么?

现在不能测试这个,但是如果你尝试这个怎么办? 查看第37.7.3.2节。退出此链接 http://www.postgresql.org/docs/8.2/static/plpgsql-control-structures.html

IF NOT FOUND THEN
    EXIT;
END IF;

或

EXIT WHEN NOT FOUND;

这个 FOUND 变量

隐式光标

SELECT * INTO myrec FROM emp WHERE empname = myname;
IF NOT FOUND THEN
    RAISE EXCEPTION 'employee % not found', myname;
END IF;

使用显式光标

...   
    LOOP
        FETCH cursor INTO whatever;
        EXIT IF NOT FOUND;
           do something with whatever
    end LOOP;