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
Phrases
RDF data
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
isfinitenumeric
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
VAD
Virtuoso Java PL API
Virtuoso Server Extension Interface (VSEI)
Web & 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;