The syntax for a
The type name may be qualified by a schema name in the normal manner. A method name however can not be qualified by a schema name in the context of a method invocation.
An instance method invocation requires that there is an instance of the user-defined type on which the method is defined. An instance is created by using the initializer function if it is distinct.
Note that if a method invocation returns a user-defined type, it is possible to use this result as an instance for further invocations.
This section summarizes standard compliance for expressions.
SQL-2016 Core Fully compliant. SQL-2016 Features outside core Feature F052, "Intervals and Datetime arithmetic".Feature F251, "Domain support" use of domain as target specification in cast expressions.Feature F690, "Collation support" support for collate clause.Feature P002, "Computational completeness".Feature T031, "Boolean datatype".
Mimer Information Technology AB
Phone: +46 18 780 92 00