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 a constructor method invocation, if the user-defined type is structured or 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.
Examplescreate type person as (name nchar varying(30), birthDate date) begin declare p person; set p = new person(); set p = p.name('Haddock').birthDate(date'1887-02-18'); ... end select person_column.name from persons order by person_column.birthDate;
The method-invocation syntax is not supported (since user-defined types are not supported.)
This section summarizes standard compliance for expressions.
SQL-2011 Core Feature E071-06 "Table operations in subqueries" is not supported, otherwise fully compliant.Fully compliant. SQL-2011 Features outside core Feature F251, "Domain support" use of domain as target specification in cast expressions.Feature F052, "Intervals and Datetime arithmetic".Feature F690, "Collation support" support for collate clause.Feature P002, "Computational completeness".Feature T031, "Boolean datatype".Feature S023, "Basic structured types".Feature S024, "Enhanced structured types".
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40