如何回滚简单的postgres udf代码

Question

这是我的代码：

create or replace function roundfind(dates date) returns varchar 
as $$
select
case 
    when dates between '2020-06-08' and '2020-11-14' then 'Round 1'
    when dates between '2020-11-15' and '2021-02-17' then 'Round 2'
    when dates between '2021-02-18' and '2021-04-28' then 'Round 3'
    when dates between '2021-04-29' and '2021-07-16' then 'Round 4'
    when dates between '2021-07-16' and '2021-10-03' then 'Round 5'
    when dates between '2021-10-04' and '2021-11-30' then 'Round 6'
    when dates between '2021-12-01' and '2022-02-01' then 'Round 7'
    when dates between '2021-02-02' and '2022-03-28' then 'Round 8'
    when dates >= '2022-03-29' then  'Round 9'
end;
$$
language sql;

select roundfind(date '2020-06-09')

此代码是正确的，但最初有一些错误，因此我收到错误“SQL 错误 [25P02]：错误：当前事务已中止，命令被忽略，直到事务块结束”。

现在，即使我运行了正确的代码，我仍然收到错误。我知道我应该以某种方式“回滚”，但不知道如何，请帮忙。