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
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
|
\set VERBOSITY 'terse'
set client_min_messages = 'warning';
set DateStyle = 'ISO, YMD';
set timezone = 'UTC';
set bytea_output = 'hex';
set extra_float_digits = 0;
\set ECHO none
select typetest('text', null);
WARNING: insert_event(q=[jsontriga], t=[{"op":"INSERT","table":["public","ttest"],"pkey":[]}], d=[{"nr":1,"val":null,"arr":"{NULL,NULL}"}])
WARNING: insert_event(q=[logutriga], t=[I:], d=[nr=1&val&arr=%7bNULL%2cNULL%7d])
WARNING: insert_event(q=[sqltriga], t=[I], d=[(nr,val,arr) values ('1',null,'{NULL,NULL}')])
typetest
----------
(1 row)
select typetest('text', $$'"quoted\string$%,@"'$$);
WARNING: insert_event(q=[jsontriga], t=[{"op":"INSERT","table":["public","ttest"],"pkey":[]}], d=[{"nr":1,"val":"'\"quoted\\string$%,@\"'","arr":"{\"'\\\"quoted\\\\string$%,@\\\"'\",\"'\\\"quoted\\\\string$%,@\\\"'\"}"}])
WARNING: insert_event(q=[logutriga], t=[I:], d=[nr=1&val=%27%22quoted%5cstring%24%25%2c%40%22%27&arr=%7b%22%27%5c%22quoted%5c%5cstring%24%25%2c%40%5c%22%27%22%2c%22%27%5c%22quoted%5c%5cstring%24%25%2c%40%5c%22%27%22%7d])
WARNING: insert_event(q=[sqltriga], t=[I], d=[(nr,val,arr) values ('1',E'''"quoted\\string$%,@"''',E'{"''\\"quoted\\\\string$%,@\\"''","''\\"quoted\\\\string$%,@\\"''"}')])
typetest
----------
(1 row)
select typetest('bytea', $$\x00FF01$$);
WARNING: insert_event(q=[jsontriga], t=[{"op":"INSERT","table":["public","ttest"],"pkey":[]}], d=[{"nr":1,"val":"\\x00ff01","arr":"{\"\\\\x00ff01\",\"\\\\x00ff01\"}"}])
WARNING: insert_event(q=[logutriga], t=[I:], d=[nr=1&val=%5cx00ff01&arr=%7b%22%5c%5cx00ff01%22%2c%22%5c%5cx00ff01%22%7d])
WARNING: insert_event(q=[sqltriga], t=[I], d=[(nr,val,arr) values ('1',E'\\x00ff01',E'{"\\\\x00ff01","\\\\x00ff01"}')])
typetest
----------
(1 row)
select typetest('bool', 'true');
WARNING: insert_event(q=[jsontriga], t=[{"op":"INSERT","table":["public","ttest"],"pkey":[]}], d=[{"nr":1,"val":true,"arr":"{t,t}"}])
WARNING: insert_event(q=[logutriga], t=[I:], d=[nr=1&val=t&arr=%7bt%2ct%7d])
WARNING: insert_event(q=[sqltriga], t=[I], d=[(nr,val,arr) values ('1','t','{t,t}')])
typetest
----------
(1 row)
select typetest('bool', 'false');
WARNING: insert_event(q=[jsontriga], t=[{"op":"INSERT","table":["public","ttest"],"pkey":[]}], d=[{"nr":1,"val":false,"arr":"{f,f}"}])
WARNING: insert_event(q=[logutriga], t=[I:], d=[nr=1&val=f&arr=%7bf%2cf%7d])
WARNING: insert_event(q=[sqltriga], t=[I], d=[(nr,val,arr) values ('1','f','{f,f}')])
typetest
----------
(1 row)
select typetest('timestamptz', '2009-09-19 11:59:48.599');
WARNING: insert_event(q=[jsontriga], t=[{"op":"INSERT","table":["public","ttest"],"pkey":[]}], d=[{"nr":1,"val":"2009-09-19T11:59:48.599+00:00","arr":"{\"2009-09-19 11:59:48.599+00\",\"2009-09-19 11:59:48.599+00\"}"}])
WARNING: insert_event(q=[logutriga], t=[I:], d=[nr=1&val=2009-09-19+11%3a59%3a48.599%2b00&arr=%7b%222009-09-19+11%3a59%3a48.599%2b00%22%2c%222009-09-19+11%3a59%3a48.599%2b00%22%7d])
WARNING: insert_event(q=[sqltriga], t=[I], d=[(nr,val,arr) values ('1','2009-09-19 11:59:48.599+00','{"2009-09-19 11:59:48.599+00","2009-09-19 11:59:48.599+00"}')])
typetest
----------
(1 row)
select typetest('timestamp', '2009-09-19 11:59:48.599');
WARNING: insert_event(q=[jsontriga], t=[{"op":"INSERT","table":["public","ttest"],"pkey":[]}], d=[{"nr":1,"val":"2009-09-19T11:59:48.599","arr":"{\"2009-09-19 11:59:48.599\",\"2009-09-19 11:59:48.599\"}"}])
WARNING: insert_event(q=[logutriga], t=[I:], d=[nr=1&val=2009-09-19+11%3a59%3a48.599&arr=%7b%222009-09-19+11%3a59%3a48.599%22%2c%222009-09-19+11%3a59%3a48.599%22%7d])
WARNING: insert_event(q=[sqltriga], t=[I], d=[(nr,val,arr) values ('1','2009-09-19 11:59:48.599','{"2009-09-19 11:59:48.599","2009-09-19 11:59:48.599"}')])
typetest
----------
(1 row)
select typetest('date', '2009-09-19');
WARNING: insert_event(q=[jsontriga], t=[{"op":"INSERT","table":["public","ttest"],"pkey":[]}], d=[{"nr":1,"val":"2009-09-19","arr":"{2009-09-19,2009-09-19}"}])
WARNING: insert_event(q=[logutriga], t=[I:], d=[nr=1&val=2009-09-19&arr=%7b2009-09-19%2c2009-09-19%7d])
WARNING: insert_event(q=[sqltriga], t=[I], d=[(nr,val,arr) values ('1','2009-09-19','{2009-09-19,2009-09-19}')])
typetest
----------
(1 row)
select typetest('time', '11:59:48.599');
WARNING: insert_event(q=[jsontriga], t=[{"op":"INSERT","table":["public","ttest"],"pkey":[]}], d=[{"nr":1,"val":"11:59:48.599","arr":"{11:59:48.599,11:59:48.599}"}])
WARNING: insert_event(q=[logutriga], t=[I:], d=[nr=1&val=11%3a59%3a48.599&arr=%7b11%3a59%3a48.599%2c11%3a59%3a48.599%7d])
WARNING: insert_event(q=[sqltriga], t=[I], d=[(nr,val,arr) values ('1','11:59:48.599','{11:59:48.599,11:59:48.599}')])
typetest
----------
(1 row)
select typetest('interval', '2 minutes');
WARNING: insert_event(q=[jsontriga], t=[{"op":"INSERT","table":["public","ttest"],"pkey":[]}], d=[{"nr":1,"val":"@ 2 mins","arr":"{\"@ 2 mins\",\"@ 2 mins\"}"}])
WARNING: insert_event(q=[logutriga], t=[I:], d=[nr=1&val=%40+2+mins&arr=%7b%22%40+2+mins%22%2c%22%40+2+mins%22%7d])
WARNING: insert_event(q=[sqltriga], t=[I], d=[(nr,val,arr) values ('1','@ 2 mins','{"@ 2 mins","@ 2 mins"}')])
typetest
----------
(1 row)
select typetest('int2', '10010');
WARNING: insert_event(q=[jsontriga], t=[{"op":"INSERT","table":["public","ttest"],"pkey":[]}], d=[{"nr":1,"val":10010,"arr":"{10010,10010}"}])
WARNING: insert_event(q=[logutriga], t=[I:], d=[nr=1&val=10010&arr=%7b10010%2c10010%7d])
WARNING: insert_event(q=[sqltriga], t=[I], d=[(nr,val,arr) values ('1','10010','{10010,10010}')])
typetest
----------
(1 row)
select typetest('int4', '100100100');
WARNING: insert_event(q=[jsontriga], t=[{"op":"INSERT","table":["public","ttest"],"pkey":[]}], d=[{"nr":1,"val":100100100,"arr":"{100100100,100100100}"}])
WARNING: insert_event(q=[logutriga], t=[I:], d=[nr=1&val=100100100&arr=%7b100100100%2c100100100%7d])
WARNING: insert_event(q=[sqltriga], t=[I], d=[(nr,val,arr) values ('1','100100100','{100100100,100100100}')])
typetest
----------
(1 row)
select typetest('int8', '100200300400500600');
WARNING: insert_event(q=[jsontriga], t=[{"op":"INSERT","table":["public","ttest"],"pkey":[]}], d=[{"nr":1,"val":100200300400500600,"arr":"{100200300400500600,100200300400500600}"}])
WARNING: insert_event(q=[logutriga], t=[I:], d=[nr=1&val=100200300400500600&arr=%7b100200300400500600%2c100200300400500600%7d])
WARNING: insert_event(q=[sqltriga], t=[I], d=[(nr,val,arr) values ('1','100200300400500600','{100200300400500600,100200300400500600}')])
typetest
----------
(1 row)
select typetest('int8', '9223372036854775807');
WARNING: insert_event(q=[jsontriga], t=[{"op":"INSERT","table":["public","ttest"],"pkey":[]}], d=[{"nr":1,"val":9223372036854775807,"arr":"{9223372036854775807,9223372036854775807}"}])
WARNING: insert_event(q=[logutriga], t=[I:], d=[nr=1&val=9223372036854775807&arr=%7b9223372036854775807%2c9223372036854775807%7d])
WARNING: insert_event(q=[sqltriga], t=[I], d=[(nr,val,arr) values ('1','9223372036854775807','{9223372036854775807,9223372036854775807}')])
typetest
----------
(1 row)
select typetest('int8', '-9223372036854775808');
WARNING: insert_event(q=[jsontriga], t=[{"op":"INSERT","table":["public","ttest"],"pkey":[]}], d=[{"nr":1,"val":-9223372036854775808,"arr":"{-9223372036854775808,-9223372036854775808}"}])
WARNING: insert_event(q=[logutriga], t=[I:], d=[nr=1&val=-9223372036854775808&arr=%7b-9223372036854775808%2c-9223372036854775808%7d])
WARNING: insert_event(q=[sqltriga], t=[I], d=[(nr,val,arr) values ('1','-9223372036854775808','{-9223372036854775808,-9223372036854775808}')])
typetest
----------
(1 row)
select typetest('oid', '100200300');
WARNING: insert_event(q=[jsontriga], t=[{"op":"INSERT","table":["public","ttest"],"pkey":[]}], d=[{"nr":1,"val":"100200300","arr":"{100200300,100200300}"}])
WARNING: insert_event(q=[logutriga], t=[I:], d=[nr=1&val=100200300&arr=%7b100200300%2c100200300%7d])
WARNING: insert_event(q=[sqltriga], t=[I], d=[(nr,val,arr) values ('1','100200300','{100200300,100200300}')])
typetest
----------
(1 row)
select typetest('xid', '100200300');
WARNING: insert_event(q=[jsontriga], t=[{"op":"INSERT","table":["public","ttest"],"pkey":[]}], d=[{"nr":1,"val":"100200300","arr":"{100200300,100200300}"}])
WARNING: insert_event(q=[logutriga], t=[I:], d=[nr=1&val=100200300&arr=%7b100200300%2c100200300%7d])
WARNING: insert_event(q=[sqltriga], t=[I], d=[(nr,val,arr) values ('1','100200300','{100200300,100200300}')])
typetest
----------
(1 row)
select typetest('tid', '100200300');
ERROR: invalid input syntax for type tid: "100200300"
select typetest('real', '100100.666');
WARNING: insert_event(q=[jsontriga], t=[{"op":"INSERT","table":["public","ttest"],"pkey":[]}], d=[{"nr":1,"val":"100101","arr":"{100101,100101}"}])
WARNING: insert_event(q=[logutriga], t=[I:], d=[nr=1&val=100101&arr=%7b100101%2c100101%7d])
WARNING: insert_event(q=[sqltriga], t=[I], d=[(nr,val,arr) values ('1','100101','{100101,100101}')])
typetest
----------
(1 row)
select typetest('float', '100100.6005005665');
WARNING: insert_event(q=[jsontriga], t=[{"op":"INSERT","table":["public","ttest"],"pkey":[]}], d=[{"nr":1,"val":"100100.600500567","arr":"{100100.600500567,100100.600500567}"}])
WARNING: insert_event(q=[logutriga], t=[I:], d=[nr=1&val=100100.600500567&arr=%7b100100.600500567%2c100100.600500567%7d])
WARNING: insert_event(q=[sqltriga], t=[I], d=[(nr,val,arr) values ('1','100100.600500567','{100100.600500567,100100.600500567}')])
typetest
----------
(1 row)
select typetest('numeric(40,15)', '100100.600500566501811');
WARNING: insert_event(q=[jsontriga], t=[{"op":"INSERT","table":["public","ttest"],"pkey":[]}], d=[{"nr":1,"val":"100100.600500566501811","arr":"{100100.600500566501811,100100.600500566501811}"}])
WARNING: insert_event(q=[logutriga], t=[I:], d=[nr=1&val=100100.600500566501811&arr=%7b100100.600500566501811%2c100100.600500566501811%7d])
WARNING: insert_event(q=[sqltriga], t=[I], d=[(nr,val,arr) values ('1','100100.600500566501811','{100100.600500566501811,100100.600500566501811}')])
typetest
----------
(1 row)
select typetest('box', '((1.1, 2.1), (5.6, 5.7))');
WARNING: insert_event(q=[jsontriga], t=[{"op":"INSERT","table":["public","ttest"],"pkey":[]}], d=[{"nr":1,"val":"(5.6,5.7),(1.1,2.1)","arr":"{(5.6,5.7),(1.1,2.1);(5.6,5.7),(1.1,2.1)}"}])
WARNING: insert_event(q=[logutriga], t=[I:], d=[nr=1&val=%285.6%2c5.7%29%2c%281.1%2c2.1%29&arr=%7b%285.6%2c5.7%29%2c%281.1%2c2.1%29%3b%285.6%2c5.7%29%2c%281.1%2c2.1%29%7d])
WARNING: insert_event(q=[sqltriga], t=[I], d=[(nr,val,arr) values ('1','(5.6,5.7),(1.1,2.1)','{(5.6,5.7),(1.1,2.1);(5.6,5.7),(1.1,2.1)}')])
typetest
----------
(1 row)
select typetest('uuid', 'a0eebc99-9c0b-4ef8-bb6d-6bb9bd380a11');
WARNING: insert_event(q=[jsontriga], t=[{"op":"INSERT","table":["public","ttest"],"pkey":[]}], d=[{"nr":1,"val":"a0eebc99-9c0b-4ef8-bb6d-6bb9bd380a11","arr":"{a0eebc99-9c0b-4ef8-bb6d-6bb9bd380a11,a0eebc99-9c0b-4ef8-bb6d-6bb9bd380a11}"}])
WARNING: insert_event(q=[logutriga], t=[I:], d=[nr=1&val=a0eebc99-9c0b-4ef8-bb6d-6bb9bd380a11&arr=%7ba0eebc99-9c0b-4ef8-bb6d-6bb9bd380a11%2ca0eebc99-9c0b-4ef8-bb6d-6bb9bd380a11%7d])
WARNING: insert_event(q=[sqltriga], t=[I], d=[(nr,val,arr) values ('1','a0eebc99-9c0b-4ef8-bb6d-6bb9bd380a11','{a0eebc99-9c0b-4ef8-bb6d-6bb9bd380a11,a0eebc99-9c0b-4ef8-bb6d-6bb9bd380a11}')])
typetest
----------
(1 row)
select typetest('json', '{"a": [false, null, true]}');
WARNING: insert_event(q=[jsontriga], t=[{"op":"INSERT","table":["public","ttest"],"pkey":[]}], d=[{"nr":1,"val":"{\"a\": [false, null, true]}","arr":"{\"{\\\"a\\\": [false, null, true]}\",\"{\\\"a\\\": [false, null, true]}\"}"}])
WARNING: insert_event(q=[logutriga], t=[I:], d=[nr=1&val=%7b%22a%22%3a+%5bfalse%2c+null%2c+true%5d%7d&arr=%7b%22%7b%5c%22a%5c%22%3a+%5bfalse%2c+null%2c+true%5d%7d%22%2c%22%7b%5c%22a%5c%22%3a+%5bfalse%2c+null%2c+true%5d%7d%22%7d])
WARNING: insert_event(q=[sqltriga], t=[I], d=[(nr,val,arr) values ('1','{"a": [false, null, true]}',E'{"{\\"a\\": [false, null, true]}","{\\"a\\": [false, null, true]}"}')])
typetest
----------
(1 row)
select typetest('json', '[1,2,3]');
WARNING: insert_event(q=[jsontriga], t=[{"op":"INSERT","table":["public","ttest"],"pkey":[]}], d=[{"nr":1,"val":"[1,2,3]","arr":"{\"[1,2,3]\",\"[1,2,3]\"}"}])
WARNING: insert_event(q=[logutriga], t=[I:], d=[nr=1&val=%5b1%2c2%2c3%5d&arr=%7b%22%5b1%2c2%2c3%5d%22%2c%22%5b1%2c2%2c3%5d%22%7d])
WARNING: insert_event(q=[sqltriga], t=[I], d=[(nr,val,arr) values ('1','[1,2,3]','{"[1,2,3]","[1,2,3]"}')])
typetest
----------
(1 row)
-- restore
drop function typetest(text,text);
\set ECHO none
|
