Name

udt_defines_field — Determines whether a user defined type contains a specified member.

Synopsis

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

Example24.425.Simple Use

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;