Hi list,
I have a
create type thetype(width integer, height integer);
create table mytable(thetype thetype[]);
How can i make an insert statement so if i later add fields to the composite type, the code/query doesn't break ?
Maybe by specifying the fields of the composite type in the query ?
This can be done for normal inserts(non arrays):
CREATE TABLE mytable (t thetype);
INSERT INTO mytable(t.width, t.height) VALUES (11,22);
Also how to update an whole element of an array of composites ?
Also, how to update an attribute in a specific element in an array of composites?
(so when i add columns later to the composite, my old code doesn't break)
How much overhead have the composite types beside the values and nulls?
Thanks