Postgres 14

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.

CREATE TYPE equipment AS ENUM ('projector','PAsystem','safe','PC','phone');

CREATE TABLE lecture_room (
   id        serial PRIMARY KEY
 , seat_count int
 , equipment equipment[]
);

CREATE TYPE



CREATE TABLE


-- with array constructor
INSERT INTO lecture_room (seat_count, equipment) VALUES 
  (120, ARRAY['projector','PAsystem','safe']);

ERROR:  column "equipment" is of type equipment[] but expression is of type text[]
LINE 3:   (120, ARRAY['projector','PAsystem','safe']);
                ^
HINT:  You will need to rewrite or cast the expression.


-- with array literal and explicit cast
INSERT INTO lecture_room (seat_count, equipment) VALUES 
  (120, '{projector,PAsystem,safe}'::equipment[]);

INSERT 0 1


-- with array literal and no explicit cast
INSERT INTO lecture_room (seat_count, equipment) VALUES 
  (120, '{projector,PAsystem,safe}');

INSERT 0 1