Postgres函数调用简单的概念问题

Question

在postgres中，一旦创建了一个函数，它只能在创建它的同一个脚本中调用，还是可以保存在DB中，我也可以访问/调用另一个脚本？

我的代码是：

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;

Answer 1

函数会自动保存在数据库中。它是数据库中的一个对象，就像一个表一样，你必须运行DROP FUNCTION才能清除它。创建函数后，每个有权访问函数架构的人都可以使用它。