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?.
select pg_typeof((1,2));
| pg_typeof |
|---|
| record |
SELECT 1
SELECT ARRAY[(1,2)] AS a
, ARRAY[(1,2)]::text AS b;
| a | b |
|---|---|
| {"(1,2)"} | {"(1,2)"} |
SELECT 1
create type dummy_type as(a int, b int);
create temp table temp_dummy_table(a int, b int);
SELECT ARRAY[(1,2)] AS a
, ARRAY[(1,2)]::text AS b
, '{"(1,2)"}'::dummy_type[]
, '{"(1,2)"}'::temp_dummy_table[];
CREATE TYPE
CREATE TABLE
| a | b | dummy_type | temp_dummy_table |
|---|---|---|---|
| {"(1,2)"} | {"(1,2)"} | {"(1,2)"} | {"(1,2)"} |
SELECT 1
SELECT ARRAY[(1,2)] AS a
, ARRAY[(1,2)]::text AS b
, '{"(1,2)"}'::record[];
ERROR: input of anonymous composite types is not implemented LINE 3: , '{"(1,2)"}'::record[]; ^