Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site


Method Invocation


The syntax for a method-invocation is:



where instance-method-invocation is:



and static-method-invocation is:



and constructor-method-invocation is:



and arguments are:



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.

Examples
 create 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;
 

Mimer SQL Experience
The method-invocation syntax is not supported (since user-defined types are not supported.)

Standard Compliance

This section summarizes standard compliance for expressions.

Standard
Compliance
Comments
SQL-2011
Core
Mimer SQL Engine:
Feature E071-06 "Table operations in subqueries" is not supported, otherwise fully compliant.
Mimer SQL Experience:
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".
Mimer SQL Engine:
Feature S023, "Basic structured types".
Feature S024, "Enhanced structured types".


Mimer
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
info@mimer.se
Mimer SQL Documentation TOC PREV NEXT INDEX