下面是PL / sql中的一个简单过程
PROCEDURE emp_get_rec (emp_rec IN OUT NOCOPY emp_content%ROWTYPE)
IS
v_cnt NUMBER;
BEGIN
SELECT COUNT(*)
INTO v_cnt
FROM emp_content
WHERE emp_id = emp_rec.emp_id;
IF v_cnt = 1
THEN
SELECT * INTO emp_rec
FROM emp_content
WHERE emp_id = emp_rec.emp_id;
END IF;
END emp_get_rec;
我试图在Postgresql中转换,
Create or replace function emp_get_rec (emp_rec IN OUT emp_content%ROWTYPE)
AS $BODY$
DECLARE
v_cnt NUMBER;
BEGIN
SELECT COUNT(*)
INTO v_cnt
FROM emp_content
WHERE emp_id = emp_rec.emp_id;
IF v_cnt = 1
THEN
SELECT * INTO emp_rec
FROM emp_content
WHERE emp_id = emp_rec.emp_id;
END IF;
END;
$BODY$LANGUAGE 'plpgsql';
我正面临以下错误：
ERROR: Syntax error at or near “ROWTYPE”
解决方法
Documentation says：
Whenever you create a table,a composite type is also automatically created,with the same name as the table,to represent the table’s row type.
因此,您可以使用表名作为类型名称,在语法上它表示类型：
create or replace function emp_get_rec (emp_rec IN OUT emp_content)
