``
//1. 创建表
create table test(
id int,
name varchar(20)
)
//2. 匿名存储过程
DO
$$
DECLARE var_r INT ;
BEGIN
SELECT INTO var_r COUNT (*) FROM test WHERE ID = '0';
IF var_r > 0 THEN
UPDATE test SET name='567' WHERE id='0';
RAISE NOTICE 'count is %,update.',var_r ;
END IF;
IF var_r = 0 THEN
INSERT INTO test (id, name) VALUES ('0', '1');
RAISE NOTICE 'count is %,insert.',var_r ;
END IF;
END
$$
``