Postgres 12

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

create table users (id serial, name text, row_status text, updated_by text);
insert into users (name) values ('foo'), ('bar'), ('baz')
3 rows affected

select * from users order by id;


id
name
row_status
updated_by


1
foo
null
null

2
bar
null
null

3
baz
null
null


create function update_status(p_id text, p_status text) 
returns text
as $$

	with 
		t_ids(id) as (select regexp_split_to_table('1, 2, 4', ',\s*')::int),
		upd as (
			update users u
			set row_status = p_status, updated_by = 'hxbisp'
			from t_ids i 
			where i.id = u.id
		)
	select 'updated: ' || string_agg(u.id::text, ', ') 
	    || ' - could not update: ' || string_agg(i.id::text, ', ') filter(where u.id is null)
	from t_ids i
	left join users u on u.id = i.id		

$$ 
language sql;
select update_status('1, 2, 4', 'zoo')


update_status


updated: 1, 2 - could not update: 4


select * from users order by id;


id
name
row_status
updated_by


1
foo
zoo
hxbisp

2
bar
zoo
hxbisp

3
baz
null
null

id	name	row_status	updated_by
1	foo	null	null
2	bar	null	null
3	baz	null	null