PostgreSQL:Array

lastmod 2021-05-03created 2021-05-031 edits

Example

Create:

CREATE TABLE sal_emp (
    name            text,
    pay_by_quarter  integer[],
    schedule        text[][]
);

Insert:

INSERT INTO sal_emp
    VALUES ('Carol',
    ARRAY[20000, 25000, 25000, 25000],
    ARRAY[['breakfast', 'consulting'], ['meeting', 'lunch']]);

Select:

SELECT name FROM sal_emp WHERE pay_by_quarter[1] <> pay_by_quarter[2];

author Zer0 sitemap