# 22. Virtuoso Functions Guide - udt_defines_field

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_defines_field

Determines whether a user defined type contains a specified member.
integer udt_defines_field (in udt any, in member_name varchar);
Description

This function is used to determine whether the supplied member_name is a member contained by the supplied udt.

Parameters
udt – A user defined type name as varchar or type instance.
member_name – The requested member name.
Return Types

This function returns either 1 (true) or 0 (false). 1 (true) is returned if the udt contains a member whose name is equal to the value of member_name, or 0 otherwise.

Examples

    select udt_defines_field (new SER_UDT(), 'A');

returns 1

    select udt_defines_field (new SER_UDT_SUB(), 'A');

returns 1

    select udt_defines_field (new SER_UDT(), 'B');

returns 0;

See Also

udt_get()

udt_implements_method()

udt_instance_of()

udt_set()