9.2.7.NEW Operator
[ NEW ] type_name ( [ parameter_value, .... ] )
This returns an instance (or reference to an instance) of the
user defined type type_name. It will try to match a constructor by
calculating the parameter types at compile time and matching the so
produced signature to the closest constructor signature (see below:
finding methods ). The SQL types have an implicit constructor
with no parameters that assigns the DEFAULT values to the type
members (if any, otherwise NULL). When a SQL constructor is called
it will have the SELF
set-up to
the result of calling the implicit constructor. The NEW operator is
a scalar expression and can be used wherever the SQL syntax allows
scalar expressions.