ARRAY Data Type

ARRAY Data Type is a SQL data type in the Data Types category. PostgreSQL: native array type. Supports multi-dimensional arrays and array functions like unnest, array_agg. The syntax is col TEXT[] / INTEGER[]. It returns array data. A typical example: CREATE TABLE students ( id SERIAL PRIMARY KEY, name TEXT, grades INTEGER[], tags TEXT[] ); INSERT INTO students VALUES (1, 'Alice', '{85, 92, 78, 95}', '{"honors", "stem"}'); -- Array access: SELECT grades[1] FROM students; -- 85 (1-based indexing) -- Array functions: SELECT unnest(grades) FROM students; -- Expands array into rows: 85, 92, 78, 95 -- Array containment: SELECT * FROM students WHERE tags @> ARRAY['honors']; -- Array length: SELECT name,… A close relative is INT, which standard integer type. Range: -2147483648 to 2147483647 (signed). Use BIGINT for larger values. A close relative is VARCHAR(n), which variable-length string with a maximum length. Most common string type. Efficient for varying-length data.