How to create Array with range in PostgreSQL

Question

In PostgreSQL, it is possible to create an array with elements (https://www.postgresql.org/docs/current/functions-array.html):

SELECT ARRAY[1,2,3,4] AS indexes;

Is there a function to generate an array by specifying begin and end? like

SELECT array_from_to(1, 4) AS indexes

Answer 1

We can use a combination of the ARRAY function with generate_series, e.g.

SELECT ARRAY(
    SELECT a.n
    FROM generate_series(1, 4) AS a(n)
);

Demo