Postgresql version 12. In a function, want to delete the users with the specific IDs (column "id" bigint). The IDs are passed in as a CSV string(VARCHAR) like this:
'1,2,3'
and the function is like this:
remove_users(in ids varchar)
and in the function want to do:
delete from users where users.id in ids
or
delete from users where users.id = any(array _ids)
how the conversion from csv string to int array be done?
>Solution :
Use built in array functions:
delete from user
where array_position(string_to_array('1,2,3', ','), id) > 0