There is a composite type:
CREATE TYPE t_well AS ( id INTEGER, name VARCHAR(10), altitude NUMERIC(10,3), x NUMERIC(10,6), y NUMERIC(10,6) );
When using this type of the queries must strictly follow the order of the columns in the definition. If I try to pass a variable of that type in the function:
SELECT * FROM p_well_operations_new(1, ROW(1, 'bla', 42, 1.99, 3.45));
you cannot change the order of columns, otherwise the value will be written incorrectly.
How to explicitly specify the columns in the composite type? Is this even possible?
Something like this for example:
SELECT * FROM p_well_operations_new(1, ROW(id=1, name='bla',...));