pgsql自定义函数学习
CREATE FUNCTION list_test_select_order(parking_id VARCHAR default '1')
RETURNS VARCHAR AS $$
DECLARE
--定义参数类型
stmt VARCHAR;
str VARCHAR;
BEGIN
stmt:=format('select id from "parking_ctrl"."p_parking_order_%s" LIMIT 1', parking_id);
raise notice '%',stmt;
EXECUTE stmt into str;
RETURN str;
EXCEPTION --捕获异常
WHEN OTHERS THEN
RETURN '1';
end; $$ LANGUAGE plpgsql;
SELECT list_test_select_order('P2du0vhdid7ebb63');
select id from "parking_ctrl"."p_parking_order_P2du0vhdid7ebb63" LIMIT 1