Postgres 12

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 address AS (
    street  text,
    city    text,
    state   text,
    zip     text
);

CREATE TYPE


CREATE TABLE customer_address (
  customer_id   INT,
  street        TEXT,
  city          TEXT,
  state         TEXT,
  zip           TEXT
)

CREATE TABLE


INSERT INTO
  customer_address
VALUES
  (1, 'A', 'B', 'C', 'D'),
  (1, 'P', 'Q', 'R', 'S'),
  (2, '1', '2', '3', '4')

INSERT 0 3


SELECT
  customer_id,
  array_agg(row(street, city, state, zip)::address)
FROM
  customer_address
GROUP BY
  customer_id


customer_id
array_agg


2
{"(1,2,3,4)"}

1
{"(A,B,C,D)","(P,Q,R,S)"}



SELECT 2