Postgresql, convert a CSV string into an array

Question

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?

Does this answer your question? Converting comma separated string to integer array in Postgres — sticky bit
– sticky bit, Commented Jan 10, 2022 at 21:23

Bohemian · Accepted Answer · 2022-01-10 22:18:18Z

6

Use built in array functions:

delete from user
where id any(string_to_array('1,2,3', ','))

edited Jan 10, 2022 at 22:18

answered Jan 10, 2022 at 21:27

Bohemian♦

427k103 gold badges603 silver badges750 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Postgresql, convert a CSV string into an array

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related