# 22. Virtuoso Functions Guide - udt_instance_of

Chapter Contents | Prev | Next
Keyword Search:
www.openlinksw.com
docs.openlinksw.com
Book Home
Contents
Preface
Virtuoso Functions Guide
Administration
Aggregate Functions
Array Manipulation
BPEL APIs
Backup
Compression
Cursor
Date & Time Manipulation
Debug
Dictionary Manipulation
Encoding & Decoding
File Manipulation
Free Text
Hashing / Cryptographic
LDAP
Locale
Mail
Miscellaneous
Number
Remote SQL Data Source
Replication
SOAP
SQL
String
Transaction
Type Mapping
import_jar
internal_to_sql_type
internal_type
internal_type_name
isarray
isbinary
isblob
isdouble
isentity
isfloat
isinteger
isnull
isnumeric
isstring
iszero
jvm_ref_import
make_string
sign
stringdate
stringtime
udt_defines_field
udt_get
udt_implements_metho...
udt_instance_of
udt_set
unimport_jar
UDDI
User Defined Types & The CLR
Virtuoso Java PL API
Virtuoso Server Extension Interface (VSEI)
Web Server & Internet
XML
XPATH & XQUERY
Functions Index

## udt_instance_of

returns the type name of supplied type or compares two input types.
varchar udt_instance_of (in udt any);
integer udt_instance_of (in udt1 any, in udt2 any);
Description

This function returns information about the supplied type(s). There are two versions of this function, one returns the name of the type of the supplied argument, and the other than compares two supplied arguments for matching types. An error will be signalled if either of the types is not defined.

Parameters
udt, udt1, udt2 – Varchar or type instance.
Return Types

udt_instance_of(udt) returns the fully qualified name of the type represented by the udt argument.

udt_instance_of(udt1, udt2) returns 1 (true) if udt1 is of the same type or a subtype of udt2. Otherwise it returns o (false).

Examples
Using udt_instance_of()

    select udt_instance_of ('SER_UDT')

returns DB.DBA.SER_UDT (if the SER_UDT type was created by DBA in the DB database).

    select udt_instance_of (new SER_UDT())

returns DB.DBA.SER_UDT (if the SER_UDT type was created by DBA in the DB database).

    select udt_instance_of ('SER_UDT_SUB', 'SER_UDT');

Returns 1

    select udt_instance_of (new SER_UDT(), 'SER_UDT_SUB');

Returns 0;

See Also

udt_get()

udt_defines_field()

udt_implements_method()

udt_set()