duplicated partial-column assigns allowed by checkInsertTargets - Mailing list pgsql-hackers

While perusing checkInsertTargets I noticed that it allows duplicated
assignments to the same member of a composite:

alvherre=# create type f as (a int, b int);
CREATE TYPE
alvherre=# create table t (col f);
CREATE TABLE
alvherre=# insert into t (col.a, col.b, col.a) values (42, 43, 44);
INSERT 0 1
alvherre=# select * from t;  col   
---------(44,43)
(1 fila)


If you instead try a duplicate "col", it is rightfully rejected:

alvherre=# insert into t (col, col) values ((42, 43), (44, 43));
ERROR:  column "col" specified more than once
LÍNEA 1: insert into t (col, col) values ((42, 43), (44, 43));                            ^

Isn't this a bit odd?

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services