Name
udt_instance_of — returns the type name of supplied type or compares two input types.
Synopsis
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
Example 24.428. 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;