I have a query that results in the folowing EXPLAIN ANALYZE:
-
Limit (cost=0.00..537.96 rows=1 width=46) (actual time=53.869..53.871 rows=1
loops=1)
- Index Scan using addr_order_idx on addr (cost=0.00..234014.08 rows=435
width=46) (actual time=53.862..53.862 rows=1
I did:
CREATE TYPE telephone AS (
area text,
number text,
ext text
);
Then:
CREATE TABLE directory (
id integer,
tel telephone,
faxes telephone[]
);
After some data has been entered, I tried:
UPDATE directory SET tel = ROW('11', '222', '333') WHERE id = 1;
UPDATE directory SET faxes[1] =