The following example adds two instance methods named toYen() and toPeso() to the structured UDT named euro:
ALTER TYPE euro /* Add 2 original methods */ ADD INSTANCE METHOD toYen() RETURNS yen LANGUAGE C PARAMETER STYLE SQL DETERMINISTIC NO SQL, toPeso() RETURNS peso LANGUAGE C PARAMETER STYLE SQL DETERMINISTIC NO SQL;