How to form a range from a set of digits in Postgres?

Question

PostgreSQL

There is a set of numbers 1,2,3,4,11,13,17,20,21,22,23,24
you need to form 1-4,11,13,17,20-24
Is this possible?

Answer 1

DBMS are meant for something else. Read data from the database, do something with it in any way convenient for you - and write back the result.