Menu
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
457
Declaration of Array Types. To illustrate the use of array types, we create this table: CREATE TABLE sal_emp ( name text, pay_by_quarter integer[], schedule text[][] ); As shown, an array data type is named by appending square brackets ( [] ) to the data type name of the array elements.
We access array elements using the subscript within square brackets [] . By default, PostgreSQL uses one-based numbering for array elements. It means the first array element starts with number 1.
Summary: PostgreSQL allows us to define a table column as an array type. The array must be of a valid data type such as integer, character, or user-defined types. To insert values into an array column, we use the ARRAY constructor.
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)
);
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
