Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SQL Anywhere 17 » SQL Anywhere Server - Spatial Data Support » Spatial data

Spatial data type syntax

The SQL/MM standard defines spatial data support in terms of user-defined extended types (UDTs) built on the ANSI/SQL CREATE TYPE statement.

Although user-defined types are not supported, the spatial data support has been implemented as though they are supported.


In this section:
    Instantiating instances of a UDT
    You can instantiate a value of a user-defined type by calling a constructor as follows:
    Using instance methods
    User defined types can have instance methods defined. Instance methods are invoked on a value of the type as follows:
    Using static methods
    In addition to instance methods, the ANSI/SQL standard allows user-defined types to have static methods associated with them.
    Using static aggregate methods (SQL Anywhere extension)
    As an extension to ANSI/SQL, SQL Anywhere supports static methods that implement user-defined aggregates.
    Using type predicates
    The ANSI/SQL standard defines type predicates that allow a statement to examine the concrete type (also called object type in other languages) of a value.
    Using the TREAT expression for subtypes
    The ANSI/SQL standard defines a subtype treatment expression that allows the declared type of an expression to be efficiently changed from a supertype to a subtype.