Amazon Redshift:在END IF点出现问题

Question

与Amazon Redshift合作，在END IF点出现问题：

CREATE OR REPLACE PROCEDURE IF_CON()
AS $$
DECLARE
BEGIN
IF(SELECT EXISTS(SELECT clientid FROM ods_epremis.new_old_merge)) THEN
BEGIN
UPDATE ods_epremis.new_old_merge SET patientencounter_id=(SELECT max(patientencounter_id) 
FROM ods_epremis.new_old_merge)+1 
WHERE new_old_merge.clain_oid =(SELECT top 1 claim_oid from ods_epremis.new_old_merge)

INSERT INTO ods_epremis.CLM_REM_MAPPING_PATIENT_ENCOUNTER
SELECT * from ods_epremis.new_old_merge
where claim_oid=(select top 1 claim_oid from ods_epremis.new_old_merge order by claim_oid)
END IF
END
$$ LANGUAGE plpgsql;

Answer 1

您的嵌套是：IF / BEGIN / END IF / END

可能应该是：IF / BEGIN / END / END IF

这将BEGIN/END事务保留在IF.中

此外，根据PL/pgSQL结构-Amazon Redshift中的示例，命令应以分号(;(:结尾

CREATE OR REPLACE PROCEDURE record_example()
LANGUAGE plpgsql
AS $$
DECLARE
rec RECORD;
BEGIN
FOR rec IN SELECT a FROM tbl_record
LOOP
RAISE INFO 'a = %', rec.a;
END LOOP;
END;
$$;