1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
|
# SQL definition for user defined types
# CAUTION: Do not modify this file unless you know what you are doing.
# Code generation can be broken if incorrect changes are made.
@include "ddlend"
%if %not {reduced-form} %then
@include "objlabel"
@include "prependedsql"
%end
[CREATE TYPE ] {name}
%if {reduced-form} %then
; {ddl-end} $br
%else
%if {base} %then
[ (] $br
%else
[ AS] $br
%end
%if {composite} %then
( $br {typeattrib} $br );
%end
%if {enumeration} %then
[ENUM ] (
%if {labels} %then {labels} %end
[);]
%end
%if {range} %then
[RANGE (] $br
[SUBTYPE = ] {subtype}
%if {collation} %then $br [, COLLATE = ] {collation} %end
%if {opclass} %then $br [, SUBTYPE_OPCLASS = ] {opclass} %end
%if {canonical} %then $br [, CANONICAL = ] {canonical} %end
%if {subtypediff} %then $br [, SUBTYPE_DIFF = ] {subtypediff} %end
);
%end
%if {base} %then
%if {input} %then $tb [INPUT = ] {input}, $br %end
%if {output} %then $tb [OUTPUT = ] {output} $br %end
%if {receive} %then $tb [, RECEIVE = ] {receive} $br %end
%if {send} %then $tb [, SEND = ] {send} $br %end
%if {tpmodin} %then $tb [, TYPMOD_IN = ] {tpmodin} $br %end
%if {tpmodout} %then $tb [, TYPMOD_OUT = ] {tpmodout} $br %end
%if {analyze} %then $tb [, ANALYZE = ] {analyze} $br %end
%if {internal-length} %then $tb [, INTERNALLENGTH = ] {internal-length} $br %end
%if {by-value} %then $tb [, PASSEDBYVALUE ] $br %end
%if {alignment} %then $tb [, ALIGNMENT = ] {alignment} $br %end
%if {storage} %then $tb [, STORAGE = ] {storage} $br %end
%if {default-value} %then $tb [, DEFAULT = ] {default-value} $br %end
%if {element} %then $tb [, ELEMENT = ] {element} $br %end
%if {delimiter} %then $tb [, DELIMITER = ] '{delimiter}' $br %end
%if {like-type} %then $tb [, LIKE = ] {like-type} $br %end
%if {category} %then $tb [, CATEGORY = ] '{category}' $br %end
%if {preferred} %then $tb [, PREFERRED = ] true $br %end
%if {collatable} %then $tb [, COLLATABLE = ] true $br %end
);
%end
@include "footer"
%end
|
