Postgres 14

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();

version

PostgreSQL 14.5 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-10), 64-bit

SELECT 1

-- setup
create table links( id   integer generated always as identity
                  , name varchar(255) 
                  ) ; 
                  
insert into links (name) 
     select 'name-' || to_char(n,'fm09')
       from generate_series(1,9) gs(n) ;
       
select * 
  from links; 
      
CREATE TABLE

INSERT 0 9

id
name

1
name-01

2
name-02

3
name-03

4
name-04

5
name-05

6
name-06

7
name-07

8
name-08

9
name-09

SELECT 9

-- delete procedure (could be function returning void)
create or replace procedure testing(first_names varchar(255))
language sql 
as $$
   delete from links 
    where name = any(string_to_array(first_names, ',')); 
$$;

CREATE PROCEDURE

-- test
do $$ 
declare 
   l_names_to_delete varchar(255) = 'name-01,name-05,name-04';
begin 
   call testing(l_names_to_delete); 
end;
$$;

DO

select * 
  from links;

id
name

2
name-02

3
name-03

6
name-06

7
name-07

8
name-08

9
name-09

SELECT 6

id	name
1	name-01
2	name-02
3	name-03
4	name-04
5	name-05
6	name-06
7	name-07
8	name-08
9	name-09