2
psql:ltree.sql:7: NOTICE: type "ltree" is not yet defined
3
DETAIL: Creating a shell type definition.
4
psql:ltree.sql:12: NOTICE: argument type ltree is only a shell
5
psql:ltree.sql:299: NOTICE: type "lquery" is not yet defined
6
DETAIL: Creating a shell type definition.
7
psql:ltree.sql:304: NOTICE: argument type lquery is only a shell
8
psql:ltree.sql:410: NOTICE: type "ltxtquery" is not yet defined
9
DETAIL: Creating a shell type definition.
10
psql:ltree.sql:415: NOTICE: argument type ltxtquery is only a shell
11
psql:ltree.sql:477: NOTICE: type "ltree_gist" is not yet defined
12
DETAIL: Creating a shell type definition.
13
psql:ltree.sql:482: NOTICE: argument type ltree_gist is only a shell
32
SELECT '1.2._3'::ltree;
38
SELECT ltree2text('1.2.3.34.sdf');
44
SELECT text2ltree('1.2.3.34.sdf');
50
SELECT subltree('Top.Child1.Child2',1,2);
56
SELECT subpath('Top.Child1.Child2',1,2);
62
SELECT subpath('Top.Child1.Child2',-1,1);
68
SELECT subpath('Top.Child1.Child2',0,-2);
74
SELECT subpath('Top.Child1.Child2',0,-1);
80
SELECT subpath('Top.Child1.Child2',0,0);
86
SELECT subpath('Top.Child1.Child2',1,0);
92
SELECT subpath('Top.Child1.Child2',0);
98
SELECT subpath('Top.Child1.Child2',1);
104
SELECT index('1.2.3.4.5.6','1.2');
110
SELECT index('a.1.2.3.4.5.6','1.2');
116
SELECT index('a.1.2.3.4.5.6','1.2.3');
122
SELECT index('a.1.2.3.4.5.6','1.2.3.j');
128
SELECT index('a.1.2.3.4.5.6','1.2.3.j.4.5.5.5.5.5.5');
134
SELECT index('a.1.2.3.4.5.6','1.2.3');
140
SELECT index('a.1.2.3.4.5.6','6');
146
SELECT index('a.1.2.3.4.5.6','6.1');
152
SELECT index('a.1.2.3.4.5.6','5.6');
158
SELECT index('0.1.2.3.5.4.5.6','5.6');
164
SELECT index('0.1.2.3.5.4.5.6.8.5.6.8','5.6',3);
170
SELECT index('0.1.2.3.5.4.5.6.8.5.6.8','5.6',6);
176
SELECT index('0.1.2.3.5.4.5.6.8.5.6.8','5.6',7);
182
SELECT index('0.1.2.3.5.4.5.6.8.5.6.8','5.6',-7);
188
SELECT index('0.1.2.3.5.4.5.6.8.5.6.8','5.6',-4);
194
SELECT index('0.1.2.3.5.4.5.6.8.5.6.8','5.6',-3);
200
SELECT index('0.1.2.3.5.4.5.6.8.5.6.8','5.6',-2);
206
SELECT index('0.1.2.3.5.4.5.6.8.5.6.8','5.6',-20000);
212
SELECT 'Top.Child1.Child2'::ltree || 'Child3'::text;
214
--------------------------
215
Top.Child1.Child2.Child3
218
SELECT 'Top.Child1.Child2'::ltree || 'Child3'::ltree;
220
--------------------------
221
Top.Child1.Child2.Child3
224
SELECT 'Top_0'::ltree || 'Top.Child1.Child2'::ltree;
226
-------------------------
227
Top_0.Top.Child1.Child2
230
SELECT 'Top.Child1.Child2'::ltree || ''::ltree;
236
SELECT ''::ltree || 'Top.Child1.Child2'::ltree;
242
SELECT lca('{la.2.3,1.2.3.4.5.6,""}') IS NULL;
248
SELECT lca('{la.2.3,1.2.3.4.5.6}') IS NULL;
254
SELECT lca('{1.la.2.3,1.2.3.4.5.6}');
260
SELECT lca('{1.2.3,1.2.3.4.5.6}');
266
SELECT lca('1.la.2.3','1.2.3.4.5.6');
272
SELECT lca('1.2.3','1.2.3.4.5.6');
278
SELECT lca('1.2.2.3','1.2.3.4.5.6');
284
SELECT lca('1.2.2.3','1.2.3.4.5.6','');
290
SELECT lca('1.2.2.3','1.2.3.4.5.6','2');
296
SELECT lca('1.2.2.3','1.2.3.4.5.6','1');
308
SELECT '4|3|2'::lquery;
314
SELECT '1.2'::lquery;
320
SELECT '1.4|3|2'::lquery;
326
SELECT '1.0'::lquery;
332
SELECT '4|3|2.0'::lquery;
338
SELECT '1.2.0'::lquery;
344
SELECT '1.4|3|2.0'::lquery;
350
SELECT '1.*'::lquery;
356
SELECT '4|3|2.*'::lquery;
362
SELECT '1.2.*'::lquery;
368
SELECT '1.4|3|2.*'::lquery;
374
SELECT '*.1.*'::lquery;
380
SELECT '*.4|3|2.*'::lquery;
386
SELECT '*.1.2.*'::lquery;
392
SELECT '*.1.4|3|2.*'::lquery;
398
SELECT '1.*.4|3|2'::lquery;
404
SELECT '1.*.4|3|2.0'::lquery;
410
SELECT '1.*.4|3|2.*{1,4}'::lquery;
416
SELECT '1.*.4|3|2.*{,4}'::lquery;
422
SELECT '1.*.4|3|2.*{1,}'::lquery;
428
SELECT '1.*.4|3|2.*{1}'::lquery;
434
SELECT 'qwerty%@*.tu'::lquery;
440
SELECT nlevel('1.2.3.4');
446
SELECT '1.2'::ltree < '2.2'::ltree;
452
SELECT '1.2'::ltree <= '2.2'::ltree;
458
SELECT '2.2'::ltree = '2.2'::ltree;
464
SELECT '3.2'::ltree >= '2.2'::ltree;
470
SELECT '3.2'::ltree > '2.2'::ltree;
476
SELECT '1.2.3'::ltree @> '1.2.3.4'::ltree;
482
SELECT '1.2.3.4'::ltree @> '1.2.3.4'::ltree;
488
SELECT '1.2.3.4.5'::ltree @> '1.2.3.4'::ltree;
494
SELECT '1.3.3'::ltree @> '1.2.3.4'::ltree;
500
SELECT 'a.b.c.d.e'::ltree ~ 'a.b.c.d.e';
506
SELECT 'a.b.c.d.e'::ltree ~ 'A.b.c.d.e';
512
SELECT 'a.b.c.d.e'::ltree ~ 'A@.b.c.d.e';
518
SELECT 'aa.b.c.d.e'::ltree ~ 'A@.b.c.d.e';
524
SELECT 'aa.b.c.d.e'::ltree ~ 'A*.b.c.d.e';
530
SELECT 'aa.b.c.d.e'::ltree ~ 'A*@.b.c.d.e';
536
SELECT 'aa.b.c.d.e'::ltree ~ 'A*@|g.b.c.d.e';
542
SELECT 'g.b.c.d.e'::ltree ~ 'A*@|g.b.c.d.e';
548
SELECT 'a.b.c.d.e'::ltree ~ 'a.b.c.d.e';
554
SELECT 'a.b.c.d.e'::ltree ~ 'a.*.e';
560
SELECT 'a.b.c.d.e'::ltree ~ 'a.*{3}.e';
566
SELECT 'a.b.c.d.e'::ltree ~ 'a.*{2}.e';
572
SELECT 'a.b.c.d.e'::ltree ~ 'a.*{4}.e';
578
SELECT 'a.b.c.d.e'::ltree ~ 'a.*{,4}.e';
584
SELECT 'a.b.c.d.e'::ltree ~ 'a.*{2,}.e';
590
SELECT 'a.b.c.d.e'::ltree ~ 'a.*{2,4}.e';
596
SELECT 'a.b.c.d.e'::ltree ~ 'a.*{2,3}.e';
602
SELECT 'a.b.c.d.e'::ltree ~ 'a.*{2,3}';
608
SELECT 'a.b.c.d.e'::ltree ~ 'a.*{2,4}';
614
SELECT 'a.b.c.d.e'::ltree ~ 'a.*{2,5}';
620
SELECT 'a.b.c.d.e'::ltree ~ '*{2,3}.e';
626
SELECT 'a.b.c.d.e'::ltree ~ '*{2,4}.e';
632
SELECT 'a.b.c.d.e'::ltree ~ '*{2,5}.e';
638
SELECT 'a.b.c.d.e'::ltree ~ '*.e';
644
SELECT 'a.b.c.d.e'::ltree ~ '*.e.*';
650
SELECT 'a.b.c.d.e'::ltree ~ '*.d.*';
656
SELECT 'a.b.c.d.e'::ltree ~ '*.a.*.d.*';
662
SELECT 'a.b.c.d.e'::ltree ~ '*.!d.*';
668
SELECT 'a.b.c.d.e'::ltree ~ '*.!d';
674
SELECT 'a.b.c.d.e'::ltree ~ '!d.*';
680
SELECT 'a.b.c.d.e'::ltree ~ '!a.*';
686
SELECT 'a.b.c.d.e'::ltree ~ '*.!e';
692
SELECT 'a.b.c.d.e'::ltree ~ '*.!e.*';
698
SELECT 'a.b.c.d.e'::ltree ~ 'a.*.!e';
704
SELECT 'a.b.c.d.e'::ltree ~ 'a.*.!d';
710
SELECT 'a.b.c.d.e'::ltree ~ 'a.*.!d.*';
716
SELECT 'a.b.c.d.e'::ltree ~ 'a.*.!f.*';
722
SELECT 'a.b.c.d.e'::ltree ~ '*.a.*.!f.*';
728
SELECT 'a.b.c.d.e'::ltree ~ '*.a.*.!d.*';
734
SELECT 'a.b.c.d.e'::ltree ~ '*.a.!d.*';
740
SELECT 'a.b.c.d.e'::ltree ~ '*.a.!d';
746
SELECT 'a.b.c.d.e'::ltree ~ 'a.!d.*';
752
SELECT 'a.b.c.d.e'::ltree ~ '*.a.*.!d.*';
758
SELECT 'a.b.c.d.e'::ltree ~ '*.!b.*';
764
SELECT 'a.b.c.d.e'::ltree ~ '*.!b.c.*';
770
SELECT 'a.b.c.d.e'::ltree ~ '*.!b.*.c.*';
776
SELECT 'a.b.c.d.e'::ltree ~ '!b.*.c.*';
782
SELECT 'a.b.c.d.e'::ltree ~ '!b.b.*';
788
SELECT 'a.b.c.d.e'::ltree ~ '!b.*.e';
794
SELECT 'a.b.c.d.e'::ltree ~ '!b.!c.*.e';
800
SELECT 'a.b.c.d.e'::ltree ~ '!b.*.!c.*.e';
806
SELECT 'a.b.c.d.e'::ltree ~ '*{2}.!b.*.!c.*.e';
812
SELECT 'a.b.c.d.e'::ltree ~ '*{1}.!b.*.!c.*.e';
818
SELECT 'a.b.c.d.e'::ltree ~ '*{1}.!b.*{1}.!c.*.e';
824
SELECT 'a.b.c.d.e'::ltree ~ 'a.!b.*{1}.!c.*.e';
830
SELECT 'a.b.c.d.e'::ltree ~ '!b.*{1}.!c.*.e';
836
SELECT 'a.b.c.d.e'::ltree ~ '*.!b.*{1}.!c.*.e';
842
SELECT 'a.b.c.d.e'::ltree ~ '*.!b.*.!c.*.e';
848
SELECT 'a.b.c.d.e'::ltree ~ '!b.!c.*';
854
SELECT 'a.b.c.d.e'::ltree ~ '!b.*.!c.*';
860
SELECT 'a.b.c.d.e'::ltree ~ '*{2}.!b.*.!c.*';
866
SELECT 'a.b.c.d.e'::ltree ~ '*{1}.!b.*.!c.*';
872
SELECT 'a.b.c.d.e'::ltree ~ '*{1}.!b.*{1}.!c.*';
878
SELECT 'a.b.c.d.e'::ltree ~ 'a.!b.*{1}.!c.*';
884
SELECT 'a.b.c.d.e'::ltree ~ '!b.*{1}.!c.*';
890
SELECT 'a.b.c.d.e'::ltree ~ '*.!b.*{1}.!c.*';
896
SELECT 'a.b.c.d.e'::ltree ~ '*.!b.*.!c.*';
902
SELECT 'QWER_TY'::ltree ~ 'q%@*';
908
SELECT 'QWER_TY'::ltree ~ 'Q_t%@*';
914
SELECT 'QWER_GY'::ltree ~ 'q_t%@*';
921
SELECT '!tree & aWdf@*'::ltxtquery;
927
SELECT 'tree & aw_qw%*'::ltxtquery;
933
SELECT 'ltree.awdfg'::ltree @ '!tree & aWdf@*'::ltxtquery;
939
SELECT 'tree.awdfg'::ltree @ '!tree & aWdf@*'::ltxtquery;
945
SELECT 'tree.awdfg'::ltree @ '!tree | aWdf@*'::ltxtquery;
951
SELECT 'tree.awdfg'::ltree @ 'tree | aWdf@*'::ltxtquery;
957
SELECT 'tree.awdfg'::ltree @ 'tree & aWdf@*'::ltxtquery;
963
SELECT 'tree.awdfg'::ltree @ 'tree & aWdf@'::ltxtquery;
969
SELECT 'tree.awdfg'::ltree @ 'tree & aWdf*'::ltxtquery;
975
SELECT 'tree.awdfg'::ltree @ 'tree & aWdf'::ltxtquery;
981
SELECT 'tree.awdfg'::ltree @ 'tree & awdf*'::ltxtquery;
987
SELECT 'tree.awdfg'::ltree @ 'tree & aWdfg@'::ltxtquery;
993
SELECT 'tree.awdfg_qwerty'::ltree @ 'tree & aw_qw%*'::ltxtquery;
999
SELECT 'tree.awdfg_qwerty'::ltree @ 'tree & aw_rw%*'::ltxtquery;
1006
SELECT '{1.2.3}'::ltree[] @> '1.2.3.4';
1012
SELECT '{1.2.3.4}'::ltree[] @> '1.2.3.4';
1018
SELECT '{1.2.3.4.5}'::ltree[] @> '1.2.3.4';
1024
SELECT '{1.3.3}'::ltree[] @> '1.2.3.4';
1030
SELECT '{5.67.8, 1.2.3}'::ltree[] @> '1.2.3.4';
1036
SELECT '{5.67.8, 1.2.3.4}'::ltree[] @> '1.2.3.4';
1042
SELECT '{5.67.8, 1.2.3.4.5}'::ltree[] @> '1.2.3.4';
1048
SELECT '{5.67.8, 1.3.3}'::ltree[] @> '1.2.3.4';
1054
SELECT '{1.2.3, 7.12.asd}'::ltree[] @> '1.2.3.4';
1060
SELECT '{1.2.3.4, 7.12.asd}'::ltree[] @> '1.2.3.4';
1066
SELECT '{1.2.3.4.5, 7.12.asd}'::ltree[] @> '1.2.3.4';
1072
SELECT '{1.3.3, 7.12.asd}'::ltree[] @> '1.2.3.4';
1078
SELECT '{ltree.asd, tree.awdfg}'::ltree[] @ 'tree & aWdfg@'::ltxtquery;
1084
SELECT '{j.k.l.m, g.b.c.d.e}'::ltree[] ~ 'A*@|g.b.c.d.e';
1090
SELECT 'a.b.c.d.e'::ltree ? '{A.b.c.d.e}';
1096
SELECT 'a.b.c.d.e'::ltree ? '{a.b.c.d.e}';
1102
SELECT 'a.b.c.d.e'::ltree ? '{A.b.c.d.e, a.*}';
1108
SELECT '{a.b.c.d.e,B.df}'::ltree[] ? '{A.b.c.d.e}';
1114
SELECT '{a.b.c.d.e,B.df}'::ltree[] ? '{A.b.c.d.e,*.df}';
1121
SELECT ('{3456,1.2.3.34}'::ltree[] ?@> '1.2.3.4') is null;
1127
SELECT '{3456,1.2.3}'::ltree[] ?@> '1.2.3.4';
1133
SELECT '{3456,1.2.3.4}'::ltree[] ?<@ '1.2.3';
1139
SELECT ('{3456,1.2.3.4}'::ltree[] ?<@ '1.2.5') is null;
1145
SELECT '{ltree.asd, tree.awdfg}'::ltree[] ?@ 'tree & aWdfg@'::ltxtquery;
1151
SELECT '{j.k.l.m, g.b.c.d.e}'::ltree[] ?~ 'A*@|g.b.c.d.e';
1157
CREATE TABLE ltreetest (t ltree);
1158
\copy ltreetest FROM 'data/ltree.data'
1159
SELECT * FROM ltreetest WHERE t < '12.3' order by t asc;
1161
----------------------------------
1177
1.11.10.19.6.1.26.17.2.22
1178
1.12.25.26.22.8.15.23
1179
1.13.16.27.11.16.30.2.9.18.4
1181
1.15.17.6.28.25.24.31.27.9
1182
1.16.8.18.14.16.21.25.6
1183
1.18.29.30.22.14.3.20.15.21.20
1184
1.19.22.11.14.7.32.23.19.14
1185
1.20.18.25.3.24.25.10.9
1190
1.25.7.9.26.17.31.20.13
1192
1.26.15.23.5.31.29.11.19.28.1
1193
1.27.22.23.2.26.32.17.7.9
1194
1.28.19.8.25.6.20.27.29.27
1196
1.29.18.1.21.12.13.27.32.15
1197
1.3.15.11.11.25.24.21.19
1198
1.30.18.31.12.25.4.19.28.12.15
1203
1.9.18.10.1.26.22.16.17
1204
10.11.25.2.24.18.18.21.6.26.21
1205
10.12.23.22.23.22.20.17.17.9
1206
10.12.9.6.6.26.14.8.23.1.25
1207
10.13.12.8.4.8.11.30
1208
10.13.22.1.8.30.9.24.1.2.1
1210
10.16.18.9.27.2.29.32.24.13
1212
10.18.12.27.24.30.32.7.11.5.13
1213
10.2.17.26.16.7.19.6.23.3
1216
10.22.30.16.2.21.17.13
1217
10.26.27.23.4.31.11.25.29
1219
10.27.7.24.26.11.31.20.29
1220
10.28.22.29.13.19.6.7.6.14
1227
10.31.25.31.24.16.17
1229
10.5.23.5.32.9.18.5.30
1234
11.1.3.28.30.21.24.14
1238
11.11.9.30.15.29.15.18
1240
11.14.21.24.10.7.29.23.24.28
1244
11.17.17.24.11.23.17.17.18.10.22
1245
11.18.4.8.3.13.14.28.18.31
1250
11.22.28.8.12.23.25.15.21.28
1254
11.30.20.15.18.32.1.18.25.26.8
1256
11.6.11.29.4.5.24.6.26.12
1262
12.10.11.9.10.31.4.16.31
1265
12.13.16.17.29.27.16.14.9.19.9
1274
12.21.15.27.24.15.8.24.24.26
1277
12.23.3.19.29.15.12.6
1279
12.25.32.2.27.3.3.16
1280
12.27.23.32.1.1.9.29.13
1282
12.28.12.24.28.15.5.12.30.13.21
1283
12.29.17.2.20.29.1.11.19.8.12
1284
12.29.26.18.4.21.28.8.13.3
1287
SELECT * FROM ltreetest WHERE t <= '12.3' order by t asc;
1289
----------------------------------
1305
1.11.10.19.6.1.26.17.2.22
1306
1.12.25.26.22.8.15.23
1307
1.13.16.27.11.16.30.2.9.18.4
1309
1.15.17.6.28.25.24.31.27.9
1310
1.16.8.18.14.16.21.25.6
1311
1.18.29.30.22.14.3.20.15.21.20
1312
1.19.22.11.14.7.32.23.19.14
1313
1.20.18.25.3.24.25.10.9
1318
1.25.7.9.26.17.31.20.13
1320
1.26.15.23.5.31.29.11.19.28.1
1321
1.27.22.23.2.26.32.17.7.9
1322
1.28.19.8.25.6.20.27.29.27
1324
1.29.18.1.21.12.13.27.32.15
1325
1.3.15.11.11.25.24.21.19
1326
1.30.18.31.12.25.4.19.28.12.15
1331
1.9.18.10.1.26.22.16.17
1332
10.11.25.2.24.18.18.21.6.26.21
1333
10.12.23.22.23.22.20.17.17.9
1334
10.12.9.6.6.26.14.8.23.1.25
1335
10.13.12.8.4.8.11.30
1336
10.13.22.1.8.30.9.24.1.2.1
1338
10.16.18.9.27.2.29.32.24.13
1340
10.18.12.27.24.30.32.7.11.5.13
1341
10.2.17.26.16.7.19.6.23.3
1344
10.22.30.16.2.21.17.13
1345
10.26.27.23.4.31.11.25.29
1347
10.27.7.24.26.11.31.20.29
1348
10.28.22.29.13.19.6.7.6.14
1355
10.31.25.31.24.16.17
1357
10.5.23.5.32.9.18.5.30
1362
11.1.3.28.30.21.24.14
1366
11.11.9.30.15.29.15.18
1368
11.14.21.24.10.7.29.23.24.28
1372
11.17.17.24.11.23.17.17.18.10.22
1373
11.18.4.8.3.13.14.28.18.31
1378
11.22.28.8.12.23.25.15.21.28
1382
11.30.20.15.18.32.1.18.25.26.8
1384
11.6.11.29.4.5.24.6.26.12
1390
12.10.11.9.10.31.4.16.31
1393
12.13.16.17.29.27.16.14.9.19.9
1402
12.21.15.27.24.15.8.24.24.26
1405
12.23.3.19.29.15.12.6
1407
12.25.32.2.27.3.3.16
1408
12.27.23.32.1.1.9.29.13
1410
12.28.12.24.28.15.5.12.30.13.21
1411
12.29.17.2.20.29.1.11.19.8.12
1412
12.29.26.18.4.21.28.8.13.3
1416
SELECT * FROM ltreetest WHERE t = '12.3' order by t asc;
1422
SELECT * FROM ltreetest WHERE t >= '12.3' order by t asc;
1424
----------------------------------
1426
12.4.10.17.4.10.23.3
1427
12.4.12.13.25.30.30.8.9.12
1429
12.4.26.23.25.5.15.7.16
1430
12.6.14.23.19.21.9.12
1431
12.7.16.8.21.22.2.16.18
1432
12.7.28.26.14.21.18.31.5.15.11
1433
13.1.6.17.28.9.15.30.1.27.14
1435
13.14.13.10.28.26.9.18.27.21
1436
13.16.1.27.18.18.19.6.14.4
1439
13.19.2.6.23.19.9.7.21.8.16
1449
13.32.15.32.26.14.32
1451
13.8.15.3.7.31.5.10.15.30
1453
13.8.23.13.11.18.24.21.11.24.10
1454
13.9.9.27.31.11.25.9.27.22.13
1456
14.1.15.25.27.23.25.26.28.10
1457
14.10.11.30.5.7.6.24.9.30.26
1460
14.13.9.13.11.5.5.2.2.32.12
1463
14.16.6.29.26.13.14.16.25.26.8
1464
14.17.7.30.8.25.26.4
1467
14.19.30.6.4.10.10.10.22.25.11
1470
14.21.5.28.3.32.24.14.25.31
1471
14.21.6.5.26.9.32.16.25
1472
14.23.31.5.5.15.17.12.17.7.3
1475
14.27.29.23.4.1.17.32.6.25.22
1477
14.3.17.1.14.15.21.4.26
1478
14.30.13.5.26.9.22.23.14.10
1482
14.4.23.4.23.22.11.6.26.5
1483
14.5.13.19.25.12.32.9.13.16.12
1484
14.6.10.29.25.26.20.24.24
1485
14.8.15.30.7.29.27.31.4
1486
14.9.15.21.21.31.1.29
1487
15.1.6.31.30.13.32.9.10
1489
15.10.30.1.4.12.8.20
1490
15.11.26.1.30.6.23.5
1496
15.25.31.11.4.22.16.7.11
1497
15.26.24.31.16.15.17.22.8.30.3
1499
15.28.30.19.31.6.2.2.31
1501
15.29.32.16.29.12.20.32.13.20
1502
15.3.31.9.27.14.9.8.14.6.32
1503
15.30.17.5.32.28.2.18.27
1504
15.31.11.27.19.19.20.5.5
1509
15.7.5.12.7.9.3.28.26
1511
15.8.3.15.27.14.29.28.6.5.25
1512
15.9.11.20.22.15.11.13
1514
16.13.19.11.18.13.17.17
1515
16.13.2.19.14.29.31.30.23.15.12
1516
16.13.26.18.9.29.11.17.1.24.26
1517
16.14.3.17.17.26.12.19.19.30
1520
16.19.17.30.30.5.17.24.27
1524
16.23.30.12.31.31.19.14
1525
16.24.3.30.15.22.31.2
1527
16.27.8.17.14.17.21.29.14
1529
16.29.6.23.13.28.31.6.19.26.15
1530
16.30.10.7.29.4.9.21.22.13.26
1531
16.31.12.27.25.9.32.29
1533
16.5.10.2.18.8.15.12.32.25.10
1534
16.5.12.5.15.12.24.25.3
1535
16.5.14.21.32.17.23.3.4.26
1539
16.9.14.28.6.21.31.31.26
1541
16.9.32.14.3.7.8.7.21.22
1543
17.10.17.22.20.25.14.13
1544
17.11.17.4.8.26.26.20.6
1545
17.13.14.29.27.27.13.12.15
1546
17.13.19.31.12.18.10.15.14
1548
17.14.7.3.2.18.20.23.18.5
1550
17.19.1.22.11.7.22.1.14.28.11
1552
17.24.15.27.3.32.4.22.20.6.24
1554
17.25.10.13.21.5.7.22.2
1555
17.25.2.13.10.27.13.1
1559
17.29.21.10.18.8.16.26.18.21.26
1560
17.29.31.8.24.10.18.27.17
1566
17.9.32.31.21.31.23.17.10.32.9
1567
18.13.6.12.26.26.26.29.18.20.1
1571
18.18.19.16.14.16.21.10.25
1573
18.19.11.20.13.13.11
1574
18.19.12.20.18.17.15.32.18.5
1576
18.24.21.17.11.26.28.22.21.18.10
1577
18.27.11.27.9.16.7.6.22.26.27
1578
18.29.13.24.18.3.12.18.12.12
1582
18.31.26.18.6.15.18.11
1583
18.31.32.28.1.4.24.24.12.25
1584
18.31.32.29.22.1.31.11.28
1589
18.6.26.2.13.9.6.11.10.11.16
1591
18.7.3.17.13.5.31.6.31.25.29
1594
19.10.26.19.5.21.30.23
1597
19.11.10.18.14.13.7.7
1598
19.11.29.13.15.27.12.15.14.12
1599
19.12.20.24.32.13.11.23.26
1607
19.19.25.22.11.6.15.3.2.19
1608
19.2.26.21.16.11.2.2
1610
19.20.25.7.27.28.27.17.9.3.1
1611
19.22.21.13.27.13.15
1612
19.22.29.32.1.21.26.24.23.17
1613
19.26.24.27.6.24.16.27.32.29
1614
19.26.32.13.1.12.30.26.22.25
1619
19.31.14.25.5.8.21.11.13.20
1621
19.6.13.14.22.13.9.29
1622
19.6.24.32.30.13.6.25.8.28
1624
19.7.29.31.3.20.7.21.25.27.29
1626
2.1.12.19.29.28.3.31.28.28.10
1628
2.10.10.4.20.1.12.13
1629
2.10.28.1.17.19.32.28
1635
2.14.10.4.17.17.8.4.27.20
1638
2.15.18.21.5.21.4.7.30
1639
2.16.3.7.22.18.29.20
1640
2.19.4.1.15.7.8.9.17.29
1641
2.2.18.18.3.3.18.8.10.8
1644
2.24.5.3.4.10.27.26.17.28.16
1647
2.30.26.10.14.31.18.2
1650
2.32.8.28.24.20.9.24.25.8.9
1651
2.4.25.32.16.22.26.13.17.18
1653
2.8.13.12.17.23.16.7.11.23
1662
20.20.32.29.24.5.5.26.22.32
1665
20.23.29.5.7.30.13.14.22
1666
20.23.7.11.11.31.18.16.3
1667
20.24.14.15.4.21.12.27.4.12
1669
20.28.22.7.10.28.27.22.14.16
1670
20.29.18.16.2.21.23.11
1675
20.31.13.12.19.2.26.16.16.22.28
1676
20.32.5.1.3.20.3.30.27
1685
21.1.4.9.9.31.24.21.3.29
1686
21.10.20.9.3.16.9.10.20
1690
21.14.25.20.13.31.14.20
1692
21.15.31.24.29.24.26.12.20
1695
21.17.31.10.31.13.9.26.6.14
1704
21.23.17.8.23.11.8.1
1705
21.28.17.22.10.27.4.20.2.32
1706
21.28.24.23.3.11.7.12.22.32
1707
21.30.19.6.28.1.32.2.14.14
1710
21.32.13.22.3.13.31.23.14.12.9
1714
21.5.17.19.15.25.18.21.24.9
1715
21.6.22.28.12.23.11.22
1716
21.7.23.9.16.5.18.14
1724
22.10.27.19.29.20.29.3.12.14.25
1728
22.13.22.8.30.32.10.24
1731
22.16.25.18.25.7.24.29.14.8
1732
22.17.24.14.21.15.12.18.17.25.11
1736
22.17.9.11.25.15.3.9
1739
22.19.21.11.6.8.29.24
1740
22.19.5.22.20.31.23.24.14.24.4
1742
22.21.32.15.8.29.5.12.10.29
1743
22.22.10.30.5.15.25.21.19.11
1744
22.22.27.6.27.15.5.18.21.28.9
1745
22.23.18.18.9.8.23.7.23.23.16
1747
22.23.25.28.5.27.9.9.24.31.10
1748
22.24.22.25.15.23.13
1749
22.25.4.28.9.20.12.13
1753
22.29.18.32.13.12.22.31.17.22
1757
22.30.31.24.23.22.5.20.28.1
1758
22.31.2.32.32.11.26.23.19
1759
22.31.21.13.13.26.11.5.19
1760
22.32.6.6.3.8.24.6.25.29
1761
22.8.20.1.10.28.6.27
1764
23.10.13.32.14.20.16.11.14
1765
23.10.5.26.12.4.20.4
1766
23.12.1.5.32.25.8.24.1.25
1767
23.12.11.11.15.16.22.31.32.5.8
1768
23.12.19.25.16.23.22.6.29.4
1769
23.12.32.22.19.1.22.4
1770
23.14.12.30.18.4.16.18.7.7
1771
23.14.30.27.28.26.26.23.8.32
1772
23.17.22.1.23.4.29.32.4.1
1773
23.17.25.4.1.16.29.10
1775
23.17.32.15.23.16.25
1776
23.19.17.31.29.13.1.12.5.25
1784
23.24.11.31.10.31.18.28.13.18.6
1790
23.28.20.25.30.24.15
1791
23.28.3.30.15.31.32.3.21.9.19
1793
23.3.32.21.5.14.10.17.1
1794
23.31.27.16.8.30.20.27
1795
23.32.5.25.19.9.15.17.15.11
1800
24.1.10.20.28.18.6.27.20.30.26
1801
24.1.29.32.14.15.32.6.15.22
1810
24.17.31.20.12.9.19.29.18
1812
24.2.26.24.14.15.31.23.17.26
1815
24.21.14.25.11.3.20.6.6.16
1817
24.23.29.8.24.11.21.10.28.14.27
1819
24.25.7.27.30.8.26.17
1821
24.27.18.32.14.9.11.28.9
1826
24.31.2.13.5.23.18.16
1828
24.32.17.23.24.19.23.9.20.18
1835
25.10.29.3.6.21.3.31.13
1843
25.17.2.20.20.3.29.21.3.12
1844
25.17.9.16.17.31.23.29.24
1845
25.18.8.3.23.23.5.9.6
1848
25.2.3.15.11.19.5.28.25.14
1859
25.32.24.24.28.15.16.10
1861
25.4.4.1.13.32.26.20.20.3
1862
25.5.30.7.16.12.21.12.11.16
1867
25.9.1.5.9.11.25.4.11.27.32
1876
26.17.9.13.4.25.32.2.24.9
1879
26.19.3.14.8.28.31.10
1881
26.24.9.12.11.15.31.2
1884
26.26.22.21.14.11.29.19.14.24
1887
26.31.16.18.22.13.32.23.9.20
1891
26.32.8.12.30.19.24.8.6.1.10
1894
26.7.5.8.11.9.22.1.6
1896
26.9.17.1.18.19.1.11.18.29.3
1900
27.11.15.9.24.31.18.4.1.30.20
1905
27.17.17.19.24.9.14.20
1909
27.19.20.1.31.29.5.22.26.3
1910
27.2.10.4.25.14.2.15.4
1912
27.21.28.24.7.2.24.23.8
1913
27.22.11.13.21.25.5.1.27.21.27
1916
27.24.11.31.21.6.29.17.24.18
1920
27.27.25.10.31.10.21.22.21.16.12
1921
27.27.30.11.15.24.9.7.4.30
1922
27.29.1.5.30.6.22.16.23.2.28
1925
27.30.12.11.20.15.11.13
1927
27.32.26.21.31.17.32.32
1930
27.4.17.17.32.8.16.15.17.13
1933
27.6.13.24.21.27.28.22.3.7.4
1935
28.11.11.30.20.11.32
1937
28.14.24.26.6.15.16.32.25.13.8
1940
28.15.25.7.13.6.19.2
1944
28.20.8.9.9.28.30.29
1945
28.23.2.30.3.8.1.15.15.14.13
1951
28.26.4.22.13.20.32.27.15
1954
28.30.24.16.17.28.2.13.10
1955
28.31.10.28.22.26.16.15
1957
28.5.12.9.2.27.11.11.2
1960
28.6.11.6.15.22.12.6
1962
28.8.21.15.16.28.4.16.26.8
1963
28.9.3.16.17.21.23.30
1968
29.10.17.11.28.12.18.5.19.15.21
1973
29.20.1.11.21.16.1.2.14.28
1975
29.23.15.25.1.6.6.10
1976
29.25.29.16.32.11.15.25.5.22.3
1977
29.25.30.15.21.3.25.26.26
1978
29.26.25.14.24.18.2.13.23.29
1981
29.27.13.9.28.29.19.13.29.31.27
1983
29.27.7.7.3.11.14.26.21.11
1992
29.5.18.27.3.21.18.6.14
1993
29.5.32.20.11.7.13.24.17
1994
29.6.12.31.20.23.32.20
1995
29.9.25.27.15.16.32.26.6.32
1996
3.1.13.22.24.14.12.31.3.4
1997
3.1.14.8.9.16.30.22.20
1999
3.10.27.4.5.6.19.12.28.12
2002
3.11.32.11.22.3.7.17.8.13.23
2004
3.14.1.14.17.28.29.16
2005
3.14.11.15.21.32.2.15.13
2007
3.15.2.23.22.2.16.14
2010
3.18.8.22.7.28.32.31.3
2013
3.20.19.10.17.27.3.6.22.23
2014
3.21.16.24.23.12.16.32.3
2016
3.22.18.1.5.14.9.6.14
2020
3.27.18.8.4.21.6.32.30.7.5
2024
3.32.2.29.3.32.28.11.29.30
2027
3.6.24.21.20.32.3.4.26.5
2028
3.9.11.23.32.26.24.28
2032
30.12.9.25.24.6.7.24.29
2034
30.16.14.9.5.4.10.7.31
2037
30.17.25.3.31.11.3.4.1.10
2041
30.20.3.2.5.15.8.7.17
2042
30.22.29.21.19.14.3.2.6
2043
30.23.10.1.10.7.22.28.18.11.17
2044
30.23.2.13.14.15.29.19.4.12.24
2046
30.24.23.25.32.18.22.12.29.9.22
2047
30.24.32.15.14.10.11
2053
30.3.16.26.7.27.26.9.27.21.18
2054
30.30.17.5.30.21.19.5.22.22.14
2057
30.4.30.11.13.23.14.24.11
2068
31.18.25.1.14.29.25.5.22.30
2069
31.18.27.15.20.29.29
2070
31.18.32.11.7.25.20.5
2071
31.21.14.20.1.22.2.5.3.27.12
2076
31.29.4.29.24.30.30.32.10.23
2078
31.30.23.7.7.24.32.10.11.1.31
2079
31.32.12.26.31.32.14.23.28
2085
32.1.23.20.14.12.23.5.32.15
2086
32.1.24.29.22.5.9.24.18.3.13
2088
32.15.20.28.5.1.23.4
2090
32.17.8.24.2.14.5.4.22
2091
32.19.20.24.23.31.8.32.16.29
2093
32.24.11.8.12.23.22.19.11.17.18
2104
32.30.18.17.1.14.12.18
2106
32.31.26.19.13.29.4.25
2109
32.6.15.26.14.15.3.19
2110
32.6.3.2.12.5.28.1.25
2113
32.6.9.26.16.4.4.29.7.11
2118
4.11.19.17.2.22.20.18.13.32.15
2119
4.11.22.4.19.24.4.28.6.8.22
2121
4.13.22.11.9.13.27.15.7
2124
4.14.16.14.1.8.1.22.17.10
2125
4.14.17.12.20.17.1.22.3
2127
4.15.20.23.12.16.2.16.17
2131
4.19.16.15.5.2.25.8.28.14.2
2132
4.2.16.13.16.11.19.10.10.25
2135
4.21.28.5.16.29.5.21
2136
4.21.9.1.2.14.8.17.13.26
2138
4.22.17.10.19.9.8.19.28.3.9
2140
4.25.12.10.15.9.18.9
2142
4.26.23.6.19.31.10.4.22
2143
4.26.5.26.21.28.17.24.25.23
2145
4.3.20.27.9.1.18.30.12.5.19
2147
4.30.8.20.19.9.30.24.11
2149
4.5.9.4.15.19.8.26.17.26.3
2157
5.13.23.19.28.26.27.6.1.22
2159
5.14.27.15.11.17.3.10.27.25
2160
5.14.29.2.23.16.20.22
2161
5.15.10.3.23.13.32.23
2165
5.2.32.19.13.29.12.13.31.29
2167
5.21.27.13.14.11.2.16.20
2171
5.24.4.31.3.16.25.17.13.26.11
2174
5.27.28.26.14.15.6.20.1.31.13
2175
5.27.32.21.5.1.11.14
2178
5.31.8.1.5.13.21.28.29.19.2
2179
5.4.8.25.12.27.2.29.28.3
2180
5.5.12.31.23.13.17.22.20
2182
5.8.17.30.15.8.19.29.30.11.6
2186
6.11.11.5.16.8.14.12.9
2187
6.11.31.23.12.8.30.14.27
2190
6.17.10.10.7.9.27.8.29
2191
6.17.26.25.27.11.10.9
2193
6.19.29.11.2.32.21.15.32.9
2195
6.19.6.4.9.11.32.17.17.3.15
2203
6.26.29.10.21.28.20.19
2205
6.27.29.14.8.12.26.3.21.4.1
2207
6.29.6.13.14.24.10.4.14.28
2208
6.5.27.19.13.26.1.18.9
2210
6.7.25.16.13.21.7.20.25.12.4
2215
7.10.17.21.11.29.17.25.19.4.29
2218
7.12.1.10.6.17.29.24.24.4
2222
7.14.22.29.30.14.25.1.9.26.25
2224
7.19.10.12.31.1.27.13.19
2225
7.19.12.3.21.19.18.5.2.14.10
2226
7.19.6.17.15.26.21.9
2228
7.23.1.24.29.13.31.19.23.17.7
2229
7.23.15.32.28.27.2.2.26
2232
7.30.19.25.23.15.14.29
2233
7.30.5.10.10.5.30.14.9.18
2235
7.31.2.28.15.11.17.18.19.23.6
2238
7.5.28.8.17.26.31.10.15
2240
7.7.22.24.17.32.17.25.28
2247
8.13.14.11.11.29.22.4.4.10
2249
8.13.9.31.20.20.24.7.23.31.28
2252
8.16.1.16.28.6.3.22.6.23
2253
8.16.20.24.20.6.10.21
2254
8.16.30.29.19.22.28.24.2
2257
8.17.9.15.21.28.1.7.1.3.6
2262
8.22.32.17.16.28.31.23.22.9
2264
8.25.20.3.15.24.7.4.24.5.30
2265
8.26.29.13.7.25.31.28.3.32
2268
8.3.18.13.30.20.27.26.17.28
2269
8.3.3.25.25.15.7.13.21.18
2272
8.5.24.9.29.32.31.30.13.9.7
2277
8.9.25.25.26.30.31.31.2.32.7
2278
9.10.19.18.15.11.22.32.32.14.9
2280
9.14.27.31.26.21.25.3.20
2281
9.16.2.16.22.24.17.31.14.21.17
2284
9.18.30.11.29.32.7.19.2
2290
9.21.28.8.12.15.3.13.10.11
2292
9.23.21.22.5.29.15.21
2294
9.28.10.26.14.26.15.14
2298
9.3.31.18.12.3.9.29.10
2300
9.31.23.19.5.10.16.4.30.24.5
2301
9.31.4.14.31.10.17.5.2
2303
9.5.9.3.23.9.25.14.1.29.28
2304
9.6.9.21.6.11.29.13.29.20.32
2310
SELECT * FROM ltreetest WHERE t > '12.3' order by t asc;
2312
----------------------------------
2313
12.4.10.17.4.10.23.3
2314
12.4.12.13.25.30.30.8.9.12
2316
12.4.26.23.25.5.15.7.16
2317
12.6.14.23.19.21.9.12
2318
12.7.16.8.21.22.2.16.18
2319
12.7.28.26.14.21.18.31.5.15.11
2320
13.1.6.17.28.9.15.30.1.27.14
2322
13.14.13.10.28.26.9.18.27.21
2323
13.16.1.27.18.18.19.6.14.4
2326
13.19.2.6.23.19.9.7.21.8.16
2336
13.32.15.32.26.14.32
2338
13.8.15.3.7.31.5.10.15.30
2340
13.8.23.13.11.18.24.21.11.24.10
2341
13.9.9.27.31.11.25.9.27.22.13
2343
14.1.15.25.27.23.25.26.28.10
2344
14.10.11.30.5.7.6.24.9.30.26
2347
14.13.9.13.11.5.5.2.2.32.12
2350
14.16.6.29.26.13.14.16.25.26.8
2351
14.17.7.30.8.25.26.4
2354
14.19.30.6.4.10.10.10.22.25.11
2357
14.21.5.28.3.32.24.14.25.31
2358
14.21.6.5.26.9.32.16.25
2359
14.23.31.5.5.15.17.12.17.7.3
2362
14.27.29.23.4.1.17.32.6.25.22
2364
14.3.17.1.14.15.21.4.26
2365
14.30.13.5.26.9.22.23.14.10
2369
14.4.23.4.23.22.11.6.26.5
2370
14.5.13.19.25.12.32.9.13.16.12
2371
14.6.10.29.25.26.20.24.24
2372
14.8.15.30.7.29.27.31.4
2373
14.9.15.21.21.31.1.29
2374
15.1.6.31.30.13.32.9.10
2376
15.10.30.1.4.12.8.20
2377
15.11.26.1.30.6.23.5
2383
15.25.31.11.4.22.16.7.11
2384
15.26.24.31.16.15.17.22.8.30.3
2386
15.28.30.19.31.6.2.2.31
2388
15.29.32.16.29.12.20.32.13.20
2389
15.3.31.9.27.14.9.8.14.6.32
2390
15.30.17.5.32.28.2.18.27
2391
15.31.11.27.19.19.20.5.5
2396
15.7.5.12.7.9.3.28.26
2398
15.8.3.15.27.14.29.28.6.5.25
2399
15.9.11.20.22.15.11.13
2401
16.13.19.11.18.13.17.17
2402
16.13.2.19.14.29.31.30.23.15.12
2403
16.13.26.18.9.29.11.17.1.24.26
2404
16.14.3.17.17.26.12.19.19.30
2407
16.19.17.30.30.5.17.24.27
2411
16.23.30.12.31.31.19.14
2412
16.24.3.30.15.22.31.2
2414
16.27.8.17.14.17.21.29.14
2416
16.29.6.23.13.28.31.6.19.26.15
2417
16.30.10.7.29.4.9.21.22.13.26
2418
16.31.12.27.25.9.32.29
2420
16.5.10.2.18.8.15.12.32.25.10
2421
16.5.12.5.15.12.24.25.3
2422
16.5.14.21.32.17.23.3.4.26
2426
16.9.14.28.6.21.31.31.26
2428
16.9.32.14.3.7.8.7.21.22
2430
17.10.17.22.20.25.14.13
2431
17.11.17.4.8.26.26.20.6
2432
17.13.14.29.27.27.13.12.15
2433
17.13.19.31.12.18.10.15.14
2435
17.14.7.3.2.18.20.23.18.5
2437
17.19.1.22.11.7.22.1.14.28.11
2439
17.24.15.27.3.32.4.22.20.6.24
2441
17.25.10.13.21.5.7.22.2
2442
17.25.2.13.10.27.13.1
2446
17.29.21.10.18.8.16.26.18.21.26
2447
17.29.31.8.24.10.18.27.17
2453
17.9.32.31.21.31.23.17.10.32.9
2454
18.13.6.12.26.26.26.29.18.20.1
2458
18.18.19.16.14.16.21.10.25
2460
18.19.11.20.13.13.11
2461
18.19.12.20.18.17.15.32.18.5
2463
18.24.21.17.11.26.28.22.21.18.10
2464
18.27.11.27.9.16.7.6.22.26.27
2465
18.29.13.24.18.3.12.18.12.12
2469
18.31.26.18.6.15.18.11
2470
18.31.32.28.1.4.24.24.12.25
2471
18.31.32.29.22.1.31.11.28
2476
18.6.26.2.13.9.6.11.10.11.16
2478
18.7.3.17.13.5.31.6.31.25.29
2481
19.10.26.19.5.21.30.23
2484
19.11.10.18.14.13.7.7
2485
19.11.29.13.15.27.12.15.14.12
2486
19.12.20.24.32.13.11.23.26
2494
19.19.25.22.11.6.15.3.2.19
2495
19.2.26.21.16.11.2.2
2497
19.20.25.7.27.28.27.17.9.3.1
2498
19.22.21.13.27.13.15
2499
19.22.29.32.1.21.26.24.23.17
2500
19.26.24.27.6.24.16.27.32.29
2501
19.26.32.13.1.12.30.26.22.25
2506
19.31.14.25.5.8.21.11.13.20
2508
19.6.13.14.22.13.9.29
2509
19.6.24.32.30.13.6.25.8.28
2511
19.7.29.31.3.20.7.21.25.27.29
2513
2.1.12.19.29.28.3.31.28.28.10
2515
2.10.10.4.20.1.12.13
2516
2.10.28.1.17.19.32.28
2522
2.14.10.4.17.17.8.4.27.20
2525
2.15.18.21.5.21.4.7.30
2526
2.16.3.7.22.18.29.20
2527
2.19.4.1.15.7.8.9.17.29
2528
2.2.18.18.3.3.18.8.10.8
2531
2.24.5.3.4.10.27.26.17.28.16
2534
2.30.26.10.14.31.18.2
2537
2.32.8.28.24.20.9.24.25.8.9
2538
2.4.25.32.16.22.26.13.17.18
2540
2.8.13.12.17.23.16.7.11.23
2549
20.20.32.29.24.5.5.26.22.32
2552
20.23.29.5.7.30.13.14.22
2553
20.23.7.11.11.31.18.16.3
2554
20.24.14.15.4.21.12.27.4.12
2556
20.28.22.7.10.28.27.22.14.16
2557
20.29.18.16.2.21.23.11
2562
20.31.13.12.19.2.26.16.16.22.28
2563
20.32.5.1.3.20.3.30.27
2572
21.1.4.9.9.31.24.21.3.29
2573
21.10.20.9.3.16.9.10.20
2577
21.14.25.20.13.31.14.20
2579
21.15.31.24.29.24.26.12.20
2582
21.17.31.10.31.13.9.26.6.14
2591
21.23.17.8.23.11.8.1
2592
21.28.17.22.10.27.4.20.2.32
2593
21.28.24.23.3.11.7.12.22.32
2594
21.30.19.6.28.1.32.2.14.14
2597
21.32.13.22.3.13.31.23.14.12.9
2601
21.5.17.19.15.25.18.21.24.9
2602
21.6.22.28.12.23.11.22
2603
21.7.23.9.16.5.18.14
2611
22.10.27.19.29.20.29.3.12.14.25
2615
22.13.22.8.30.32.10.24
2618
22.16.25.18.25.7.24.29.14.8
2619
22.17.24.14.21.15.12.18.17.25.11
2623
22.17.9.11.25.15.3.9
2626
22.19.21.11.6.8.29.24
2627
22.19.5.22.20.31.23.24.14.24.4
2629
22.21.32.15.8.29.5.12.10.29
2630
22.22.10.30.5.15.25.21.19.11
2631
22.22.27.6.27.15.5.18.21.28.9
2632
22.23.18.18.9.8.23.7.23.23.16
2634
22.23.25.28.5.27.9.9.24.31.10
2635
22.24.22.25.15.23.13
2636
22.25.4.28.9.20.12.13
2640
22.29.18.32.13.12.22.31.17.22
2644
22.30.31.24.23.22.5.20.28.1
2645
22.31.2.32.32.11.26.23.19
2646
22.31.21.13.13.26.11.5.19
2647
22.32.6.6.3.8.24.6.25.29
2648
22.8.20.1.10.28.6.27
2651
23.10.13.32.14.20.16.11.14
2652
23.10.5.26.12.4.20.4
2653
23.12.1.5.32.25.8.24.1.25
2654
23.12.11.11.15.16.22.31.32.5.8
2655
23.12.19.25.16.23.22.6.29.4
2656
23.12.32.22.19.1.22.4
2657
23.14.12.30.18.4.16.18.7.7
2658
23.14.30.27.28.26.26.23.8.32
2659
23.17.22.1.23.4.29.32.4.1
2660
23.17.25.4.1.16.29.10
2662
23.17.32.15.23.16.25
2663
23.19.17.31.29.13.1.12.5.25
2671
23.24.11.31.10.31.18.28.13.18.6
2677
23.28.20.25.30.24.15
2678
23.28.3.30.15.31.32.3.21.9.19
2680
23.3.32.21.5.14.10.17.1
2681
23.31.27.16.8.30.20.27
2682
23.32.5.25.19.9.15.17.15.11
2687
24.1.10.20.28.18.6.27.20.30.26
2688
24.1.29.32.14.15.32.6.15.22
2697
24.17.31.20.12.9.19.29.18
2699
24.2.26.24.14.15.31.23.17.26
2702
24.21.14.25.11.3.20.6.6.16
2704
24.23.29.8.24.11.21.10.28.14.27
2706
24.25.7.27.30.8.26.17
2708
24.27.18.32.14.9.11.28.9
2713
24.31.2.13.5.23.18.16
2715
24.32.17.23.24.19.23.9.20.18
2722
25.10.29.3.6.21.3.31.13
2730
25.17.2.20.20.3.29.21.3.12
2731
25.17.9.16.17.31.23.29.24
2732
25.18.8.3.23.23.5.9.6
2735
25.2.3.15.11.19.5.28.25.14
2746
25.32.24.24.28.15.16.10
2748
25.4.4.1.13.32.26.20.20.3
2749
25.5.30.7.16.12.21.12.11.16
2754
25.9.1.5.9.11.25.4.11.27.32
2763
26.17.9.13.4.25.32.2.24.9
2766
26.19.3.14.8.28.31.10
2768
26.24.9.12.11.15.31.2
2771
26.26.22.21.14.11.29.19.14.24
2774
26.31.16.18.22.13.32.23.9.20
2778
26.32.8.12.30.19.24.8.6.1.10
2781
26.7.5.8.11.9.22.1.6
2783
26.9.17.1.18.19.1.11.18.29.3
2787
27.11.15.9.24.31.18.4.1.30.20
2792
27.17.17.19.24.9.14.20
2796
27.19.20.1.31.29.5.22.26.3
2797
27.2.10.4.25.14.2.15.4
2799
27.21.28.24.7.2.24.23.8
2800
27.22.11.13.21.25.5.1.27.21.27
2803
27.24.11.31.21.6.29.17.24.18
2807
27.27.25.10.31.10.21.22.21.16.12
2808
27.27.30.11.15.24.9.7.4.30
2809
27.29.1.5.30.6.22.16.23.2.28
2812
27.30.12.11.20.15.11.13
2814
27.32.26.21.31.17.32.32
2817
27.4.17.17.32.8.16.15.17.13
2820
27.6.13.24.21.27.28.22.3.7.4
2822
28.11.11.30.20.11.32
2824
28.14.24.26.6.15.16.32.25.13.8
2827
28.15.25.7.13.6.19.2
2831
28.20.8.9.9.28.30.29
2832
28.23.2.30.3.8.1.15.15.14.13
2838
28.26.4.22.13.20.32.27.15
2841
28.30.24.16.17.28.2.13.10
2842
28.31.10.28.22.26.16.15
2844
28.5.12.9.2.27.11.11.2
2847
28.6.11.6.15.22.12.6
2849
28.8.21.15.16.28.4.16.26.8
2850
28.9.3.16.17.21.23.30
2855
29.10.17.11.28.12.18.5.19.15.21
2860
29.20.1.11.21.16.1.2.14.28
2862
29.23.15.25.1.6.6.10
2863
29.25.29.16.32.11.15.25.5.22.3
2864
29.25.30.15.21.3.25.26.26
2865
29.26.25.14.24.18.2.13.23.29
2868
29.27.13.9.28.29.19.13.29.31.27
2870
29.27.7.7.3.11.14.26.21.11
2879
29.5.18.27.3.21.18.6.14
2880
29.5.32.20.11.7.13.24.17
2881
29.6.12.31.20.23.32.20
2882
29.9.25.27.15.16.32.26.6.32
2883
3.1.13.22.24.14.12.31.3.4
2884
3.1.14.8.9.16.30.22.20
2886
3.10.27.4.5.6.19.12.28.12
2889
3.11.32.11.22.3.7.17.8.13.23
2891
3.14.1.14.17.28.29.16
2892
3.14.11.15.21.32.2.15.13
2894
3.15.2.23.22.2.16.14
2897
3.18.8.22.7.28.32.31.3
2900
3.20.19.10.17.27.3.6.22.23
2901
3.21.16.24.23.12.16.32.3
2903
3.22.18.1.5.14.9.6.14
2907
3.27.18.8.4.21.6.32.30.7.5
2911
3.32.2.29.3.32.28.11.29.30
2914
3.6.24.21.20.32.3.4.26.5
2915
3.9.11.23.32.26.24.28
2919
30.12.9.25.24.6.7.24.29
2921
30.16.14.9.5.4.10.7.31
2924
30.17.25.3.31.11.3.4.1.10
2928
30.20.3.2.5.15.8.7.17
2929
30.22.29.21.19.14.3.2.6
2930
30.23.10.1.10.7.22.28.18.11.17
2931
30.23.2.13.14.15.29.19.4.12.24
2933
30.24.23.25.32.18.22.12.29.9.22
2934
30.24.32.15.14.10.11
2940
30.3.16.26.7.27.26.9.27.21.18
2941
30.30.17.5.30.21.19.5.22.22.14
2944
30.4.30.11.13.23.14.24.11
2955
31.18.25.1.14.29.25.5.22.30
2956
31.18.27.15.20.29.29
2957
31.18.32.11.7.25.20.5
2958
31.21.14.20.1.22.2.5.3.27.12
2963
31.29.4.29.24.30.30.32.10.23
2965
31.30.23.7.7.24.32.10.11.1.31
2966
31.32.12.26.31.32.14.23.28
2972
32.1.23.20.14.12.23.5.32.15
2973
32.1.24.29.22.5.9.24.18.3.13
2975
32.15.20.28.5.1.23.4
2977
32.17.8.24.2.14.5.4.22
2978
32.19.20.24.23.31.8.32.16.29
2980
32.24.11.8.12.23.22.19.11.17.18
2991
32.30.18.17.1.14.12.18
2993
32.31.26.19.13.29.4.25
2996
32.6.15.26.14.15.3.19
2997
32.6.3.2.12.5.28.1.25
3000
32.6.9.26.16.4.4.29.7.11
3005
4.11.19.17.2.22.20.18.13.32.15
3006
4.11.22.4.19.24.4.28.6.8.22
3008
4.13.22.11.9.13.27.15.7
3011
4.14.16.14.1.8.1.22.17.10
3012
4.14.17.12.20.17.1.22.3
3014
4.15.20.23.12.16.2.16.17
3018
4.19.16.15.5.2.25.8.28.14.2
3019
4.2.16.13.16.11.19.10.10.25
3022
4.21.28.5.16.29.5.21
3023
4.21.9.1.2.14.8.17.13.26
3025
4.22.17.10.19.9.8.19.28.3.9
3027
4.25.12.10.15.9.18.9
3029
4.26.23.6.19.31.10.4.22
3030
4.26.5.26.21.28.17.24.25.23
3032
4.3.20.27.9.1.18.30.12.5.19
3034
4.30.8.20.19.9.30.24.11
3036
4.5.9.4.15.19.8.26.17.26.3
3044
5.13.23.19.28.26.27.6.1.22
3046
5.14.27.15.11.17.3.10.27.25
3047
5.14.29.2.23.16.20.22
3048
5.15.10.3.23.13.32.23
3052
5.2.32.19.13.29.12.13.31.29
3054
5.21.27.13.14.11.2.16.20
3058
5.24.4.31.3.16.25.17.13.26.11
3061
5.27.28.26.14.15.6.20.1.31.13
3062
5.27.32.21.5.1.11.14
3065
5.31.8.1.5.13.21.28.29.19.2
3066
5.4.8.25.12.27.2.29.28.3
3067
5.5.12.31.23.13.17.22.20
3069
5.8.17.30.15.8.19.29.30.11.6
3073
6.11.11.5.16.8.14.12.9
3074
6.11.31.23.12.8.30.14.27
3077
6.17.10.10.7.9.27.8.29
3078
6.17.26.25.27.11.10.9
3080
6.19.29.11.2.32.21.15.32.9
3082
6.19.6.4.9.11.32.17.17.3.15
3090
6.26.29.10.21.28.20.19
3092
6.27.29.14.8.12.26.3.21.4.1
3094
6.29.6.13.14.24.10.4.14.28
3095
6.5.27.19.13.26.1.18.9
3097
6.7.25.16.13.21.7.20.25.12.4
3102
7.10.17.21.11.29.17.25.19.4.29
3105
7.12.1.10.6.17.29.24.24.4
3109
7.14.22.29.30.14.25.1.9.26.25
3111
7.19.10.12.31.1.27.13.19
3112
7.19.12.3.21.19.18.5.2.14.10
3113
7.19.6.17.15.26.21.9
3115
7.23.1.24.29.13.31.19.23.17.7
3116
7.23.15.32.28.27.2.2.26
3119
7.30.19.25.23.15.14.29
3120
7.30.5.10.10.5.30.14.9.18
3122
7.31.2.28.15.11.17.18.19.23.6
3125
7.5.28.8.17.26.31.10.15
3127
7.7.22.24.17.32.17.25.28
3134
8.13.14.11.11.29.22.4.4.10
3136
8.13.9.31.20.20.24.7.23.31.28
3139
8.16.1.16.28.6.3.22.6.23
3140
8.16.20.24.20.6.10.21
3141
8.16.30.29.19.22.28.24.2
3144
8.17.9.15.21.28.1.7.1.3.6
3149
8.22.32.17.16.28.31.23.22.9
3151
8.25.20.3.15.24.7.4.24.5.30
3152
8.26.29.13.7.25.31.28.3.32
3155
8.3.18.13.30.20.27.26.17.28
3156
8.3.3.25.25.15.7.13.21.18
3159
8.5.24.9.29.32.31.30.13.9.7
3164
8.9.25.25.26.30.31.31.2.32.7
3165
9.10.19.18.15.11.22.32.32.14.9
3167
9.14.27.31.26.21.25.3.20
3168
9.16.2.16.22.24.17.31.14.21.17
3171
9.18.30.11.29.32.7.19.2
3177
9.21.28.8.12.15.3.13.10.11
3179
9.23.21.22.5.29.15.21
3181
9.28.10.26.14.26.15.14
3185
9.3.31.18.12.3.9.29.10
3187
9.31.23.19.5.10.16.4.30.24.5
3188
9.31.4.14.31.10.17.5.2
3190
9.5.9.3.23.9.25.14.1.29.28
3191
9.6.9.21.6.11.29.13.29.20.32
3197
SELECT * FROM ltreetest WHERE t @> '1.1.1' order by t asc;
3206
SELECT * FROM ltreetest WHERE t <@ '1.1.1' order by t asc;
3215
SELECT * FROM ltreetest WHERE t @ '23 & 1' order by t asc;
3217
--------------------------------
3220
1.12.25.26.22.8.15.23
3221
1.19.22.11.14.7.32.23.19.14
3223
1.26.15.23.5.31.29.11.19.28.1
3224
1.27.22.23.2.26.32.17.7.9
3225
10.12.9.6.6.26.14.8.23.1.25
3226
12.27.23.32.1.1.9.29.13
3227
14.1.15.25.27.23.25.26.28.10
3228
14.27.29.23.4.1.17.32.6.25.22
3229
15.11.26.1.30.6.23.5
3230
19.22.29.32.1.21.26.24.23.17
3232
21.23.17.8.23.11.8.1
3233
22.30.31.24.23.22.5.20.28.1
3235
23.12.1.5.32.25.8.24.1.25
3236
23.12.32.22.19.1.22.4
3237
23.17.22.1.23.4.29.32.4.1
3238
23.17.25.4.1.16.29.10
3239
23.19.17.31.29.13.1.12.5.25
3242
23.3.32.21.5.14.10.17.1
3243
27.29.1.5.30.6.22.16.23.2.28
3244
28.23.2.30.3.8.1.15.15.14.13
3246
29.23.15.25.1.6.6.10
3247
30.23.10.1.10.7.22.28.18.11.17
3248
31.30.23.7.7.24.32.10.11.1.31
3249
32.1.23.20.14.12.23.5.32.15
3250
32.15.20.28.5.1.23.4
3251
5.13.23.19.28.26.27.6.1.22
3253
7.23.1.24.29.13.31.19.23.17.7
3254
8.16.1.16.28.6.3.22.6.23
3256
9.5.9.3.23.9.25.14.1.29.28
3259
SELECT * FROM ltreetest WHERE t ~ '1.1.1.*' order by t asc;
3268
SELECT * FROM ltreetest WHERE t ~ '*.1' order by t asc;
3270
--------------------------------
3277
1.26.15.23.5.31.29.11.19.28.1
3278
10.13.22.1.8.30.9.24.1.2.1
3283
17.25.2.13.10.27.13.1
3284
18.13.6.12.26.26.26.29.18.20.1
3285
19.20.25.7.27.28.27.17.9.3.1
3290
21.23.17.8.23.11.8.1
3291
22.30.31.24.23.22.5.20.28.1
3292
23.17.22.1.23.4.29.32.4.1
3294
23.3.32.21.5.14.10.17.1
3300
6.27.29.14.8.12.26.3.21.4.1
3307
SELECT * FROM ltreetest WHERE t ~ '23.*{1}.1' order by t asc;
3313
SELECT * FROM ltreetest WHERE t ~ '23.*.1' order by t asc;
3315
---------------------------
3316
23.17.22.1.23.4.29.32.4.1
3318
23.3.32.21.5.14.10.17.1
3321
SELECT * FROM ltreetest WHERE t ~ '23.*.2' order by t asc;
3327
SELECT * FROM ltreetest WHERE t ? '{23.*.1,23.*.2}' order by t asc;
3329
---------------------------
3330
23.17.22.1.23.4.29.32.4.1
3333
23.3.32.21.5.14.10.17.1
3336
create unique index tstidx on ltreetest (t);
3337
set enable_seqscan=off;
3338
SELECT * FROM ltreetest WHERE t < '12.3' order by t asc;
3340
----------------------------------
3356
1.11.10.19.6.1.26.17.2.22
3357
1.12.25.26.22.8.15.23
3358
1.13.16.27.11.16.30.2.9.18.4
3360
1.15.17.6.28.25.24.31.27.9
3361
1.16.8.18.14.16.21.25.6
3362
1.18.29.30.22.14.3.20.15.21.20
3363
1.19.22.11.14.7.32.23.19.14
3364
1.20.18.25.3.24.25.10.9
3369
1.25.7.9.26.17.31.20.13
3371
1.26.15.23.5.31.29.11.19.28.1
3372
1.27.22.23.2.26.32.17.7.9
3373
1.28.19.8.25.6.20.27.29.27
3375
1.29.18.1.21.12.13.27.32.15
3376
1.3.15.11.11.25.24.21.19
3377
1.30.18.31.12.25.4.19.28.12.15
3382
1.9.18.10.1.26.22.16.17
3383
10.11.25.2.24.18.18.21.6.26.21
3384
10.12.23.22.23.22.20.17.17.9
3385
10.12.9.6.6.26.14.8.23.1.25
3386
10.13.12.8.4.8.11.30
3387
10.13.22.1.8.30.9.24.1.2.1
3389
10.16.18.9.27.2.29.32.24.13
3391
10.18.12.27.24.30.32.7.11.5.13
3392
10.2.17.26.16.7.19.6.23.3
3395
10.22.30.16.2.21.17.13
3396
10.26.27.23.4.31.11.25.29
3398
10.27.7.24.26.11.31.20.29
3399
10.28.22.29.13.19.6.7.6.14
3406
10.31.25.31.24.16.17
3408
10.5.23.5.32.9.18.5.30
3413
11.1.3.28.30.21.24.14
3417
11.11.9.30.15.29.15.18
3419
11.14.21.24.10.7.29.23.24.28
3423
11.17.17.24.11.23.17.17.18.10.22
3424
11.18.4.8.3.13.14.28.18.31
3429
11.22.28.8.12.23.25.15.21.28
3433
11.30.20.15.18.32.1.18.25.26.8
3435
11.6.11.29.4.5.24.6.26.12
3441
12.10.11.9.10.31.4.16.31
3444
12.13.16.17.29.27.16.14.9.19.9
3453
12.21.15.27.24.15.8.24.24.26
3456
12.23.3.19.29.15.12.6
3458
12.25.32.2.27.3.3.16
3459
12.27.23.32.1.1.9.29.13
3461
12.28.12.24.28.15.5.12.30.13.21
3462
12.29.17.2.20.29.1.11.19.8.12
3463
12.29.26.18.4.21.28.8.13.3
3466
SELECT * FROM ltreetest WHERE t <= '12.3' order by t asc;
3468
----------------------------------
3484
1.11.10.19.6.1.26.17.2.22
3485
1.12.25.26.22.8.15.23
3486
1.13.16.27.11.16.30.2.9.18.4
3488
1.15.17.6.28.25.24.31.27.9
3489
1.16.8.18.14.16.21.25.6
3490
1.18.29.30.22.14.3.20.15.21.20
3491
1.19.22.11.14.7.32.23.19.14
3492
1.20.18.25.3.24.25.10.9
3497
1.25.7.9.26.17.31.20.13
3499
1.26.15.23.5.31.29.11.19.28.1
3500
1.27.22.23.2.26.32.17.7.9
3501
1.28.19.8.25.6.20.27.29.27
3503
1.29.18.1.21.12.13.27.32.15
3504
1.3.15.11.11.25.24.21.19
3505
1.30.18.31.12.25.4.19.28.12.15
3510
1.9.18.10.1.26.22.16.17
3511
10.11.25.2.24.18.18.21.6.26.21
3512
10.12.23.22.23.22.20.17.17.9
3513
10.12.9.6.6.26.14.8.23.1.25
3514
10.13.12.8.4.8.11.30
3515
10.13.22.1.8.30.9.24.1.2.1
3517
10.16.18.9.27.2.29.32.24.13
3519
10.18.12.27.24.30.32.7.11.5.13
3520
10.2.17.26.16.7.19.6.23.3
3523
10.22.30.16.2.21.17.13
3524
10.26.27.23.4.31.11.25.29
3526
10.27.7.24.26.11.31.20.29
3527
10.28.22.29.13.19.6.7.6.14
3534
10.31.25.31.24.16.17
3536
10.5.23.5.32.9.18.5.30
3541
11.1.3.28.30.21.24.14
3545
11.11.9.30.15.29.15.18
3547
11.14.21.24.10.7.29.23.24.28
3551
11.17.17.24.11.23.17.17.18.10.22
3552
11.18.4.8.3.13.14.28.18.31
3557
11.22.28.8.12.23.25.15.21.28
3561
11.30.20.15.18.32.1.18.25.26.8
3563
11.6.11.29.4.5.24.6.26.12
3569
12.10.11.9.10.31.4.16.31
3572
12.13.16.17.29.27.16.14.9.19.9
3581
12.21.15.27.24.15.8.24.24.26
3584
12.23.3.19.29.15.12.6
3586
12.25.32.2.27.3.3.16
3587
12.27.23.32.1.1.9.29.13
3589
12.28.12.24.28.15.5.12.30.13.21
3590
12.29.17.2.20.29.1.11.19.8.12
3591
12.29.26.18.4.21.28.8.13.3
3595
SELECT * FROM ltreetest WHERE t = '12.3' order by t asc;
3601
SELECT * FROM ltreetest WHERE t >= '12.3' order by t asc;
3603
----------------------------------
3605
12.4.10.17.4.10.23.3
3606
12.4.12.13.25.30.30.8.9.12
3608
12.4.26.23.25.5.15.7.16
3609
12.6.14.23.19.21.9.12
3610
12.7.16.8.21.22.2.16.18
3611
12.7.28.26.14.21.18.31.5.15.11
3612
13.1.6.17.28.9.15.30.1.27.14
3614
13.14.13.10.28.26.9.18.27.21
3615
13.16.1.27.18.18.19.6.14.4
3618
13.19.2.6.23.19.9.7.21.8.16
3628
13.32.15.32.26.14.32
3630
13.8.15.3.7.31.5.10.15.30
3632
13.8.23.13.11.18.24.21.11.24.10
3633
13.9.9.27.31.11.25.9.27.22.13
3635
14.1.15.25.27.23.25.26.28.10
3636
14.10.11.30.5.7.6.24.9.30.26
3639
14.13.9.13.11.5.5.2.2.32.12
3642
14.16.6.29.26.13.14.16.25.26.8
3643
14.17.7.30.8.25.26.4
3646
14.19.30.6.4.10.10.10.22.25.11
3649
14.21.5.28.3.32.24.14.25.31
3650
14.21.6.5.26.9.32.16.25
3651
14.23.31.5.5.15.17.12.17.7.3
3654
14.27.29.23.4.1.17.32.6.25.22
3656
14.3.17.1.14.15.21.4.26
3657
14.30.13.5.26.9.22.23.14.10
3661
14.4.23.4.23.22.11.6.26.5
3662
14.5.13.19.25.12.32.9.13.16.12
3663
14.6.10.29.25.26.20.24.24
3664
14.8.15.30.7.29.27.31.4
3665
14.9.15.21.21.31.1.29
3666
15.1.6.31.30.13.32.9.10
3668
15.10.30.1.4.12.8.20
3669
15.11.26.1.30.6.23.5
3675
15.25.31.11.4.22.16.7.11
3676
15.26.24.31.16.15.17.22.8.30.3
3678
15.28.30.19.31.6.2.2.31
3680
15.29.32.16.29.12.20.32.13.20
3681
15.3.31.9.27.14.9.8.14.6.32
3682
15.30.17.5.32.28.2.18.27
3683
15.31.11.27.19.19.20.5.5
3688
15.7.5.12.7.9.3.28.26
3690
15.8.3.15.27.14.29.28.6.5.25
3691
15.9.11.20.22.15.11.13
3693
16.13.19.11.18.13.17.17
3694
16.13.2.19.14.29.31.30.23.15.12
3695
16.13.26.18.9.29.11.17.1.24.26
3696
16.14.3.17.17.26.12.19.19.30
3699
16.19.17.30.30.5.17.24.27
3703
16.23.30.12.31.31.19.14
3704
16.24.3.30.15.22.31.2
3706
16.27.8.17.14.17.21.29.14
3708
16.29.6.23.13.28.31.6.19.26.15
3709
16.30.10.7.29.4.9.21.22.13.26
3710
16.31.12.27.25.9.32.29
3712
16.5.10.2.18.8.15.12.32.25.10
3713
16.5.12.5.15.12.24.25.3
3714
16.5.14.21.32.17.23.3.4.26
3718
16.9.14.28.6.21.31.31.26
3720
16.9.32.14.3.7.8.7.21.22
3722
17.10.17.22.20.25.14.13
3723
17.11.17.4.8.26.26.20.6
3724
17.13.14.29.27.27.13.12.15
3725
17.13.19.31.12.18.10.15.14
3727
17.14.7.3.2.18.20.23.18.5
3729
17.19.1.22.11.7.22.1.14.28.11
3731
17.24.15.27.3.32.4.22.20.6.24
3733
17.25.10.13.21.5.7.22.2
3734
17.25.2.13.10.27.13.1
3738
17.29.21.10.18.8.16.26.18.21.26
3739
17.29.31.8.24.10.18.27.17
3745
17.9.32.31.21.31.23.17.10.32.9
3746
18.13.6.12.26.26.26.29.18.20.1
3750
18.18.19.16.14.16.21.10.25
3752
18.19.11.20.13.13.11
3753
18.19.12.20.18.17.15.32.18.5
3755
18.24.21.17.11.26.28.22.21.18.10
3756
18.27.11.27.9.16.7.6.22.26.27
3757
18.29.13.24.18.3.12.18.12.12
3761
18.31.26.18.6.15.18.11
3762
18.31.32.28.1.4.24.24.12.25
3763
18.31.32.29.22.1.31.11.28
3768
18.6.26.2.13.9.6.11.10.11.16
3770
18.7.3.17.13.5.31.6.31.25.29
3773
19.10.26.19.5.21.30.23
3776
19.11.10.18.14.13.7.7
3777
19.11.29.13.15.27.12.15.14.12
3778
19.12.20.24.32.13.11.23.26
3786
19.19.25.22.11.6.15.3.2.19
3787
19.2.26.21.16.11.2.2
3789
19.20.25.7.27.28.27.17.9.3.1
3790
19.22.21.13.27.13.15
3791
19.22.29.32.1.21.26.24.23.17
3792
19.26.24.27.6.24.16.27.32.29
3793
19.26.32.13.1.12.30.26.22.25
3798
19.31.14.25.5.8.21.11.13.20
3800
19.6.13.14.22.13.9.29
3801
19.6.24.32.30.13.6.25.8.28
3803
19.7.29.31.3.20.7.21.25.27.29
3805
2.1.12.19.29.28.3.31.28.28.10
3807
2.10.10.4.20.1.12.13
3808
2.10.28.1.17.19.32.28
3814
2.14.10.4.17.17.8.4.27.20
3817
2.15.18.21.5.21.4.7.30
3818
2.16.3.7.22.18.29.20
3819
2.19.4.1.15.7.8.9.17.29
3820
2.2.18.18.3.3.18.8.10.8
3823
2.24.5.3.4.10.27.26.17.28.16
3826
2.30.26.10.14.31.18.2
3829
2.32.8.28.24.20.9.24.25.8.9
3830
2.4.25.32.16.22.26.13.17.18
3832
2.8.13.12.17.23.16.7.11.23
3841
20.20.32.29.24.5.5.26.22.32
3844
20.23.29.5.7.30.13.14.22
3845
20.23.7.11.11.31.18.16.3
3846
20.24.14.15.4.21.12.27.4.12
3848
20.28.22.7.10.28.27.22.14.16
3849
20.29.18.16.2.21.23.11
3854
20.31.13.12.19.2.26.16.16.22.28
3855
20.32.5.1.3.20.3.30.27
3864
21.1.4.9.9.31.24.21.3.29
3865
21.10.20.9.3.16.9.10.20
3869
21.14.25.20.13.31.14.20
3871
21.15.31.24.29.24.26.12.20
3874
21.17.31.10.31.13.9.26.6.14
3883
21.23.17.8.23.11.8.1
3884
21.28.17.22.10.27.4.20.2.32
3885
21.28.24.23.3.11.7.12.22.32
3886
21.30.19.6.28.1.32.2.14.14
3889
21.32.13.22.3.13.31.23.14.12.9
3893
21.5.17.19.15.25.18.21.24.9
3894
21.6.22.28.12.23.11.22
3895
21.7.23.9.16.5.18.14
3903
22.10.27.19.29.20.29.3.12.14.25
3907
22.13.22.8.30.32.10.24
3910
22.16.25.18.25.7.24.29.14.8
3911
22.17.24.14.21.15.12.18.17.25.11
3915
22.17.9.11.25.15.3.9
3918
22.19.21.11.6.8.29.24
3919
22.19.5.22.20.31.23.24.14.24.4
3921
22.21.32.15.8.29.5.12.10.29
3922
22.22.10.30.5.15.25.21.19.11
3923
22.22.27.6.27.15.5.18.21.28.9
3924
22.23.18.18.9.8.23.7.23.23.16
3926
22.23.25.28.5.27.9.9.24.31.10
3927
22.24.22.25.15.23.13
3928
22.25.4.28.9.20.12.13
3932
22.29.18.32.13.12.22.31.17.22
3936
22.30.31.24.23.22.5.20.28.1
3937
22.31.2.32.32.11.26.23.19
3938
22.31.21.13.13.26.11.5.19
3939
22.32.6.6.3.8.24.6.25.29
3940
22.8.20.1.10.28.6.27
3943
23.10.13.32.14.20.16.11.14
3944
23.10.5.26.12.4.20.4
3945
23.12.1.5.32.25.8.24.1.25
3946
23.12.11.11.15.16.22.31.32.5.8
3947
23.12.19.25.16.23.22.6.29.4
3948
23.12.32.22.19.1.22.4
3949
23.14.12.30.18.4.16.18.7.7
3950
23.14.30.27.28.26.26.23.8.32
3951
23.17.22.1.23.4.29.32.4.1
3952
23.17.25.4.1.16.29.10
3954
23.17.32.15.23.16.25
3955
23.19.17.31.29.13.1.12.5.25
3963
23.24.11.31.10.31.18.28.13.18.6
3969
23.28.20.25.30.24.15
3970
23.28.3.30.15.31.32.3.21.9.19
3972
23.3.32.21.5.14.10.17.1
3973
23.31.27.16.8.30.20.27
3974
23.32.5.25.19.9.15.17.15.11
3979
24.1.10.20.28.18.6.27.20.30.26
3980
24.1.29.32.14.15.32.6.15.22
3989
24.17.31.20.12.9.19.29.18
3991
24.2.26.24.14.15.31.23.17.26
3994
24.21.14.25.11.3.20.6.6.16
3996
24.23.29.8.24.11.21.10.28.14.27
3998
24.25.7.27.30.8.26.17
4000
24.27.18.32.14.9.11.28.9
4005
24.31.2.13.5.23.18.16
4007
24.32.17.23.24.19.23.9.20.18
4014
25.10.29.3.6.21.3.31.13
4022
25.17.2.20.20.3.29.21.3.12
4023
25.17.9.16.17.31.23.29.24
4024
25.18.8.3.23.23.5.9.6
4027
25.2.3.15.11.19.5.28.25.14
4038
25.32.24.24.28.15.16.10
4040
25.4.4.1.13.32.26.20.20.3
4041
25.5.30.7.16.12.21.12.11.16
4046
25.9.1.5.9.11.25.4.11.27.32
4055
26.17.9.13.4.25.32.2.24.9
4058
26.19.3.14.8.28.31.10
4060
26.24.9.12.11.15.31.2
4063
26.26.22.21.14.11.29.19.14.24
4066
26.31.16.18.22.13.32.23.9.20
4070
26.32.8.12.30.19.24.8.6.1.10
4073
26.7.5.8.11.9.22.1.6
4075
26.9.17.1.18.19.1.11.18.29.3
4079
27.11.15.9.24.31.18.4.1.30.20
4084
27.17.17.19.24.9.14.20
4088
27.19.20.1.31.29.5.22.26.3
4089
27.2.10.4.25.14.2.15.4
4091
27.21.28.24.7.2.24.23.8
4092
27.22.11.13.21.25.5.1.27.21.27
4095
27.24.11.31.21.6.29.17.24.18
4099
27.27.25.10.31.10.21.22.21.16.12
4100
27.27.30.11.15.24.9.7.4.30
4101
27.29.1.5.30.6.22.16.23.2.28
4104
27.30.12.11.20.15.11.13
4106
27.32.26.21.31.17.32.32
4109
27.4.17.17.32.8.16.15.17.13
4112
27.6.13.24.21.27.28.22.3.7.4
4114
28.11.11.30.20.11.32
4116
28.14.24.26.6.15.16.32.25.13.8
4119
28.15.25.7.13.6.19.2
4123
28.20.8.9.9.28.30.29
4124
28.23.2.30.3.8.1.15.15.14.13
4130
28.26.4.22.13.20.32.27.15
4133
28.30.24.16.17.28.2.13.10
4134
28.31.10.28.22.26.16.15
4136
28.5.12.9.2.27.11.11.2
4139
28.6.11.6.15.22.12.6
4141
28.8.21.15.16.28.4.16.26.8
4142
28.9.3.16.17.21.23.30
4147
29.10.17.11.28.12.18.5.19.15.21
4152
29.20.1.11.21.16.1.2.14.28
4154
29.23.15.25.1.6.6.10
4155
29.25.29.16.32.11.15.25.5.22.3
4156
29.25.30.15.21.3.25.26.26
4157
29.26.25.14.24.18.2.13.23.29
4160
29.27.13.9.28.29.19.13.29.31.27
4162
29.27.7.7.3.11.14.26.21.11
4171
29.5.18.27.3.21.18.6.14
4172
29.5.32.20.11.7.13.24.17
4173
29.6.12.31.20.23.32.20
4174
29.9.25.27.15.16.32.26.6.32
4175
3.1.13.22.24.14.12.31.3.4
4176
3.1.14.8.9.16.30.22.20
4178
3.10.27.4.5.6.19.12.28.12
4181
3.11.32.11.22.3.7.17.8.13.23
4183
3.14.1.14.17.28.29.16
4184
3.14.11.15.21.32.2.15.13
4186
3.15.2.23.22.2.16.14
4189
3.18.8.22.7.28.32.31.3
4192
3.20.19.10.17.27.3.6.22.23
4193
3.21.16.24.23.12.16.32.3
4195
3.22.18.1.5.14.9.6.14
4199
3.27.18.8.4.21.6.32.30.7.5
4203
3.32.2.29.3.32.28.11.29.30
4206
3.6.24.21.20.32.3.4.26.5
4207
3.9.11.23.32.26.24.28
4211
30.12.9.25.24.6.7.24.29
4213
30.16.14.9.5.4.10.7.31
4216
30.17.25.3.31.11.3.4.1.10
4220
30.20.3.2.5.15.8.7.17
4221
30.22.29.21.19.14.3.2.6
4222
30.23.10.1.10.7.22.28.18.11.17
4223
30.23.2.13.14.15.29.19.4.12.24
4225
30.24.23.25.32.18.22.12.29.9.22
4226
30.24.32.15.14.10.11
4232
30.3.16.26.7.27.26.9.27.21.18
4233
30.30.17.5.30.21.19.5.22.22.14
4236
30.4.30.11.13.23.14.24.11
4247
31.18.25.1.14.29.25.5.22.30
4248
31.18.27.15.20.29.29
4249
31.18.32.11.7.25.20.5
4250
31.21.14.20.1.22.2.5.3.27.12
4255
31.29.4.29.24.30.30.32.10.23
4257
31.30.23.7.7.24.32.10.11.1.31
4258
31.32.12.26.31.32.14.23.28
4264
32.1.23.20.14.12.23.5.32.15
4265
32.1.24.29.22.5.9.24.18.3.13
4267
32.15.20.28.5.1.23.4
4269
32.17.8.24.2.14.5.4.22
4270
32.19.20.24.23.31.8.32.16.29
4272
32.24.11.8.12.23.22.19.11.17.18
4283
32.30.18.17.1.14.12.18
4285
32.31.26.19.13.29.4.25
4288
32.6.15.26.14.15.3.19
4289
32.6.3.2.12.5.28.1.25
4292
32.6.9.26.16.4.4.29.7.11
4297
4.11.19.17.2.22.20.18.13.32.15
4298
4.11.22.4.19.24.4.28.6.8.22
4300
4.13.22.11.9.13.27.15.7
4303
4.14.16.14.1.8.1.22.17.10
4304
4.14.17.12.20.17.1.22.3
4306
4.15.20.23.12.16.2.16.17
4310
4.19.16.15.5.2.25.8.28.14.2
4311
4.2.16.13.16.11.19.10.10.25
4314
4.21.28.5.16.29.5.21
4315
4.21.9.1.2.14.8.17.13.26
4317
4.22.17.10.19.9.8.19.28.3.9
4319
4.25.12.10.15.9.18.9
4321
4.26.23.6.19.31.10.4.22
4322
4.26.5.26.21.28.17.24.25.23
4324
4.3.20.27.9.1.18.30.12.5.19
4326
4.30.8.20.19.9.30.24.11
4328
4.5.9.4.15.19.8.26.17.26.3
4336
5.13.23.19.28.26.27.6.1.22
4338
5.14.27.15.11.17.3.10.27.25
4339
5.14.29.2.23.16.20.22
4340
5.15.10.3.23.13.32.23
4344
5.2.32.19.13.29.12.13.31.29
4346
5.21.27.13.14.11.2.16.20
4350
5.24.4.31.3.16.25.17.13.26.11
4353
5.27.28.26.14.15.6.20.1.31.13
4354
5.27.32.21.5.1.11.14
4357
5.31.8.1.5.13.21.28.29.19.2
4358
5.4.8.25.12.27.2.29.28.3
4359
5.5.12.31.23.13.17.22.20
4361
5.8.17.30.15.8.19.29.30.11.6
4365
6.11.11.5.16.8.14.12.9
4366
6.11.31.23.12.8.30.14.27
4369
6.17.10.10.7.9.27.8.29
4370
6.17.26.25.27.11.10.9
4372
6.19.29.11.2.32.21.15.32.9
4374
6.19.6.4.9.11.32.17.17.3.15
4382
6.26.29.10.21.28.20.19
4384
6.27.29.14.8.12.26.3.21.4.1
4386
6.29.6.13.14.24.10.4.14.28
4387
6.5.27.19.13.26.1.18.9
4389
6.7.25.16.13.21.7.20.25.12.4
4394
7.10.17.21.11.29.17.25.19.4.29
4397
7.12.1.10.6.17.29.24.24.4
4401
7.14.22.29.30.14.25.1.9.26.25
4403
7.19.10.12.31.1.27.13.19
4404
7.19.12.3.21.19.18.5.2.14.10
4405
7.19.6.17.15.26.21.9
4407
7.23.1.24.29.13.31.19.23.17.7
4408
7.23.15.32.28.27.2.2.26
4411
7.30.19.25.23.15.14.29
4412
7.30.5.10.10.5.30.14.9.18
4414
7.31.2.28.15.11.17.18.19.23.6
4417
7.5.28.8.17.26.31.10.15
4419
7.7.22.24.17.32.17.25.28
4426
8.13.14.11.11.29.22.4.4.10
4428
8.13.9.31.20.20.24.7.23.31.28
4431
8.16.1.16.28.6.3.22.6.23
4432
8.16.20.24.20.6.10.21
4433
8.16.30.29.19.22.28.24.2
4436
8.17.9.15.21.28.1.7.1.3.6
4441
8.22.32.17.16.28.31.23.22.9
4443
8.25.20.3.15.24.7.4.24.5.30
4444
8.26.29.13.7.25.31.28.3.32
4447
8.3.18.13.30.20.27.26.17.28
4448
8.3.3.25.25.15.7.13.21.18
4451
8.5.24.9.29.32.31.30.13.9.7
4456
8.9.25.25.26.30.31.31.2.32.7
4457
9.10.19.18.15.11.22.32.32.14.9
4459
9.14.27.31.26.21.25.3.20
4460
9.16.2.16.22.24.17.31.14.21.17
4463
9.18.30.11.29.32.7.19.2
4469
9.21.28.8.12.15.3.13.10.11
4471
9.23.21.22.5.29.15.21
4473
9.28.10.26.14.26.15.14
4477
9.3.31.18.12.3.9.29.10
4479
9.31.23.19.5.10.16.4.30.24.5
4480
9.31.4.14.31.10.17.5.2
4482
9.5.9.3.23.9.25.14.1.29.28
4483
9.6.9.21.6.11.29.13.29.20.32
4489
SELECT * FROM ltreetest WHERE t > '12.3' order by t asc;
4491
----------------------------------
4492
12.4.10.17.4.10.23.3
4493
12.4.12.13.25.30.30.8.9.12
4495
12.4.26.23.25.5.15.7.16
4496
12.6.14.23.19.21.9.12
4497
12.7.16.8.21.22.2.16.18
4498
12.7.28.26.14.21.18.31.5.15.11
4499
13.1.6.17.28.9.15.30.1.27.14
4501
13.14.13.10.28.26.9.18.27.21
4502
13.16.1.27.18.18.19.6.14.4
4505
13.19.2.6.23.19.9.7.21.8.16
4515
13.32.15.32.26.14.32
4517
13.8.15.3.7.31.5.10.15.30
4519
13.8.23.13.11.18.24.21.11.24.10
4520
13.9.9.27.31.11.25.9.27.22.13
4522
14.1.15.25.27.23.25.26.28.10
4523
14.10.11.30.5.7.6.24.9.30.26
4526
14.13.9.13.11.5.5.2.2.32.12
4529
14.16.6.29.26.13.14.16.25.26.8
4530
14.17.7.30.8.25.26.4
4533
14.19.30.6.4.10.10.10.22.25.11
4536
14.21.5.28.3.32.24.14.25.31
4537
14.21.6.5.26.9.32.16.25
4538
14.23.31.5.5.15.17.12.17.7.3
4541
14.27.29.23.4.1.17.32.6.25.22
4543
14.3.17.1.14.15.21.4.26
4544
14.30.13.5.26.9.22.23.14.10
4548
14.4.23.4.23.22.11.6.26.5
4549
14.5.13.19.25.12.32.9.13.16.12
4550
14.6.10.29.25.26.20.24.24
4551
14.8.15.30.7.29.27.31.4
4552
14.9.15.21.21.31.1.29
4553
15.1.6.31.30.13.32.9.10
4555
15.10.30.1.4.12.8.20
4556
15.11.26.1.30.6.23.5
4562
15.25.31.11.4.22.16.7.11
4563
15.26.24.31.16.15.17.22.8.30.3
4565
15.28.30.19.31.6.2.2.31
4567
15.29.32.16.29.12.20.32.13.20
4568
15.3.31.9.27.14.9.8.14.6.32
4569
15.30.17.5.32.28.2.18.27
4570
15.31.11.27.19.19.20.5.5
4575
15.7.5.12.7.9.3.28.26
4577
15.8.3.15.27.14.29.28.6.5.25
4578
15.9.11.20.22.15.11.13
4580
16.13.19.11.18.13.17.17
4581
16.13.2.19.14.29.31.30.23.15.12
4582
16.13.26.18.9.29.11.17.1.24.26
4583
16.14.3.17.17.26.12.19.19.30
4586
16.19.17.30.30.5.17.24.27
4590
16.23.30.12.31.31.19.14
4591
16.24.3.30.15.22.31.2
4593
16.27.8.17.14.17.21.29.14
4595
16.29.6.23.13.28.31.6.19.26.15
4596
16.30.10.7.29.4.9.21.22.13.26
4597
16.31.12.27.25.9.32.29
4599
16.5.10.2.18.8.15.12.32.25.10
4600
16.5.12.5.15.12.24.25.3
4601
16.5.14.21.32.17.23.3.4.26
4605
16.9.14.28.6.21.31.31.26
4607
16.9.32.14.3.7.8.7.21.22
4609
17.10.17.22.20.25.14.13
4610
17.11.17.4.8.26.26.20.6
4611
17.13.14.29.27.27.13.12.15
4612
17.13.19.31.12.18.10.15.14
4614
17.14.7.3.2.18.20.23.18.5
4616
17.19.1.22.11.7.22.1.14.28.11
4618
17.24.15.27.3.32.4.22.20.6.24
4620
17.25.10.13.21.5.7.22.2
4621
17.25.2.13.10.27.13.1
4625
17.29.21.10.18.8.16.26.18.21.26
4626
17.29.31.8.24.10.18.27.17
4632
17.9.32.31.21.31.23.17.10.32.9
4633
18.13.6.12.26.26.26.29.18.20.1
4637
18.18.19.16.14.16.21.10.25
4639
18.19.11.20.13.13.11
4640
18.19.12.20.18.17.15.32.18.5
4642
18.24.21.17.11.26.28.22.21.18.10
4643
18.27.11.27.9.16.7.6.22.26.27
4644
18.29.13.24.18.3.12.18.12.12
4648
18.31.26.18.6.15.18.11
4649
18.31.32.28.1.4.24.24.12.25
4650
18.31.32.29.22.1.31.11.28
4655
18.6.26.2.13.9.6.11.10.11.16
4657
18.7.3.17.13.5.31.6.31.25.29
4660
19.10.26.19.5.21.30.23
4663
19.11.10.18.14.13.7.7
4664
19.11.29.13.15.27.12.15.14.12
4665
19.12.20.24.32.13.11.23.26
4673
19.19.25.22.11.6.15.3.2.19
4674
19.2.26.21.16.11.2.2
4676
19.20.25.7.27.28.27.17.9.3.1
4677
19.22.21.13.27.13.15
4678
19.22.29.32.1.21.26.24.23.17
4679
19.26.24.27.6.24.16.27.32.29
4680
19.26.32.13.1.12.30.26.22.25
4685
19.31.14.25.5.8.21.11.13.20
4687
19.6.13.14.22.13.9.29
4688
19.6.24.32.30.13.6.25.8.28
4690
19.7.29.31.3.20.7.21.25.27.29
4692
2.1.12.19.29.28.3.31.28.28.10
4694
2.10.10.4.20.1.12.13
4695
2.10.28.1.17.19.32.28
4701
2.14.10.4.17.17.8.4.27.20
4704
2.15.18.21.5.21.4.7.30
4705
2.16.3.7.22.18.29.20
4706
2.19.4.1.15.7.8.9.17.29
4707
2.2.18.18.3.3.18.8.10.8
4710
2.24.5.3.4.10.27.26.17.28.16
4713
2.30.26.10.14.31.18.2
4716
2.32.8.28.24.20.9.24.25.8.9
4717
2.4.25.32.16.22.26.13.17.18
4719
2.8.13.12.17.23.16.7.11.23
4728
20.20.32.29.24.5.5.26.22.32
4731
20.23.29.5.7.30.13.14.22
4732
20.23.7.11.11.31.18.16.3
4733
20.24.14.15.4.21.12.27.4.12
4735
20.28.22.7.10.28.27.22.14.16
4736
20.29.18.16.2.21.23.11
4741
20.31.13.12.19.2.26.16.16.22.28
4742
20.32.5.1.3.20.3.30.27
4751
21.1.4.9.9.31.24.21.3.29
4752
21.10.20.9.3.16.9.10.20
4756
21.14.25.20.13.31.14.20
4758
21.15.31.24.29.24.26.12.20
4761
21.17.31.10.31.13.9.26.6.14
4770
21.23.17.8.23.11.8.1
4771
21.28.17.22.10.27.4.20.2.32
4772
21.28.24.23.3.11.7.12.22.32
4773
21.30.19.6.28.1.32.2.14.14
4776
21.32.13.22.3.13.31.23.14.12.9
4780
21.5.17.19.15.25.18.21.24.9
4781
21.6.22.28.12.23.11.22
4782
21.7.23.9.16.5.18.14
4790
22.10.27.19.29.20.29.3.12.14.25
4794
22.13.22.8.30.32.10.24
4797
22.16.25.18.25.7.24.29.14.8
4798
22.17.24.14.21.15.12.18.17.25.11
4802
22.17.9.11.25.15.3.9
4805
22.19.21.11.6.8.29.24
4806
22.19.5.22.20.31.23.24.14.24.4
4808
22.21.32.15.8.29.5.12.10.29
4809
22.22.10.30.5.15.25.21.19.11
4810
22.22.27.6.27.15.5.18.21.28.9
4811
22.23.18.18.9.8.23.7.23.23.16
4813
22.23.25.28.5.27.9.9.24.31.10
4814
22.24.22.25.15.23.13
4815
22.25.4.28.9.20.12.13
4819
22.29.18.32.13.12.22.31.17.22
4823
22.30.31.24.23.22.5.20.28.1
4824
22.31.2.32.32.11.26.23.19
4825
22.31.21.13.13.26.11.5.19
4826
22.32.6.6.3.8.24.6.25.29
4827
22.8.20.1.10.28.6.27
4830
23.10.13.32.14.20.16.11.14
4831
23.10.5.26.12.4.20.4
4832
23.12.1.5.32.25.8.24.1.25
4833
23.12.11.11.15.16.22.31.32.5.8
4834
23.12.19.25.16.23.22.6.29.4
4835
23.12.32.22.19.1.22.4
4836
23.14.12.30.18.4.16.18.7.7
4837
23.14.30.27.28.26.26.23.8.32
4838
23.17.22.1.23.4.29.32.4.1
4839
23.17.25.4.1.16.29.10
4841
23.17.32.15.23.16.25
4842
23.19.17.31.29.13.1.12.5.25
4850
23.24.11.31.10.31.18.28.13.18.6
4856
23.28.20.25.30.24.15
4857
23.28.3.30.15.31.32.3.21.9.19
4859
23.3.32.21.5.14.10.17.1
4860
23.31.27.16.8.30.20.27
4861
23.32.5.25.19.9.15.17.15.11
4866
24.1.10.20.28.18.6.27.20.30.26
4867
24.1.29.32.14.15.32.6.15.22
4876
24.17.31.20.12.9.19.29.18
4878
24.2.26.24.14.15.31.23.17.26
4881
24.21.14.25.11.3.20.6.6.16
4883
24.23.29.8.24.11.21.10.28.14.27
4885
24.25.7.27.30.8.26.17
4887
24.27.18.32.14.9.11.28.9
4892
24.31.2.13.5.23.18.16
4894
24.32.17.23.24.19.23.9.20.18
4901
25.10.29.3.6.21.3.31.13
4909
25.17.2.20.20.3.29.21.3.12
4910
25.17.9.16.17.31.23.29.24
4911
25.18.8.3.23.23.5.9.6
4914
25.2.3.15.11.19.5.28.25.14
4925
25.32.24.24.28.15.16.10
4927
25.4.4.1.13.32.26.20.20.3
4928
25.5.30.7.16.12.21.12.11.16
4933
25.9.1.5.9.11.25.4.11.27.32
4942
26.17.9.13.4.25.32.2.24.9
4945
26.19.3.14.8.28.31.10
4947
26.24.9.12.11.15.31.2
4950
26.26.22.21.14.11.29.19.14.24
4953
26.31.16.18.22.13.32.23.9.20
4957
26.32.8.12.30.19.24.8.6.1.10
4960
26.7.5.8.11.9.22.1.6
4962
26.9.17.1.18.19.1.11.18.29.3
4966
27.11.15.9.24.31.18.4.1.30.20
4971
27.17.17.19.24.9.14.20
4975
27.19.20.1.31.29.5.22.26.3
4976
27.2.10.4.25.14.2.15.4
4978
27.21.28.24.7.2.24.23.8
4979
27.22.11.13.21.25.5.1.27.21.27
4982
27.24.11.31.21.6.29.17.24.18
4986
27.27.25.10.31.10.21.22.21.16.12
4987
27.27.30.11.15.24.9.7.4.30
4988
27.29.1.5.30.6.22.16.23.2.28
4991
27.30.12.11.20.15.11.13
4993
27.32.26.21.31.17.32.32
4996
27.4.17.17.32.8.16.15.17.13
4999
27.6.13.24.21.27.28.22.3.7.4
5001
28.11.11.30.20.11.32
5003
28.14.24.26.6.15.16.32.25.13.8
5006
28.15.25.7.13.6.19.2
5010
28.20.8.9.9.28.30.29
5011
28.23.2.30.3.8.1.15.15.14.13
5017
28.26.4.22.13.20.32.27.15
5020
28.30.24.16.17.28.2.13.10
5021
28.31.10.28.22.26.16.15
5023
28.5.12.9.2.27.11.11.2
5026
28.6.11.6.15.22.12.6
5028
28.8.21.15.16.28.4.16.26.8
5029
28.9.3.16.17.21.23.30
5034
29.10.17.11.28.12.18.5.19.15.21
5039
29.20.1.11.21.16.1.2.14.28
5041
29.23.15.25.1.6.6.10
5042
29.25.29.16.32.11.15.25.5.22.3
5043
29.25.30.15.21.3.25.26.26
5044
29.26.25.14.24.18.2.13.23.29
5047
29.27.13.9.28.29.19.13.29.31.27
5049
29.27.7.7.3.11.14.26.21.11
5058
29.5.18.27.3.21.18.6.14
5059
29.5.32.20.11.7.13.24.17
5060
29.6.12.31.20.23.32.20
5061
29.9.25.27.15.16.32.26.6.32
5062
3.1.13.22.24.14.12.31.3.4
5063
3.1.14.8.9.16.30.22.20
5065
3.10.27.4.5.6.19.12.28.12
5068
3.11.32.11.22.3.7.17.8.13.23
5070
3.14.1.14.17.28.29.16
5071
3.14.11.15.21.32.2.15.13
5073
3.15.2.23.22.2.16.14
5076
3.18.8.22.7.28.32.31.3
5079
3.20.19.10.17.27.3.6.22.23
5080
3.21.16.24.23.12.16.32.3
5082
3.22.18.1.5.14.9.6.14
5086
3.27.18.8.4.21.6.32.30.7.5
5090
3.32.2.29.3.32.28.11.29.30
5093
3.6.24.21.20.32.3.4.26.5
5094
3.9.11.23.32.26.24.28
5098
30.12.9.25.24.6.7.24.29
5100
30.16.14.9.5.4.10.7.31
5103
30.17.25.3.31.11.3.4.1.10
5107
30.20.3.2.5.15.8.7.17
5108
30.22.29.21.19.14.3.2.6
5109
30.23.10.1.10.7.22.28.18.11.17
5110
30.23.2.13.14.15.29.19.4.12.24
5112
30.24.23.25.32.18.22.12.29.9.22
5113
30.24.32.15.14.10.11
5119
30.3.16.26.7.27.26.9.27.21.18
5120
30.30.17.5.30.21.19.5.22.22.14
5123
30.4.30.11.13.23.14.24.11
5134
31.18.25.1.14.29.25.5.22.30
5135
31.18.27.15.20.29.29
5136
31.18.32.11.7.25.20.5
5137
31.21.14.20.1.22.2.5.3.27.12
5142
31.29.4.29.24.30.30.32.10.23
5144
31.30.23.7.7.24.32.10.11.1.31
5145
31.32.12.26.31.32.14.23.28
5151
32.1.23.20.14.12.23.5.32.15
5152
32.1.24.29.22.5.9.24.18.3.13
5154
32.15.20.28.5.1.23.4
5156
32.17.8.24.2.14.5.4.22
5157
32.19.20.24.23.31.8.32.16.29
5159
32.24.11.8.12.23.22.19.11.17.18
5170
32.30.18.17.1.14.12.18
5172
32.31.26.19.13.29.4.25
5175
32.6.15.26.14.15.3.19
5176
32.6.3.2.12.5.28.1.25
5179
32.6.9.26.16.4.4.29.7.11
5184
4.11.19.17.2.22.20.18.13.32.15
5185
4.11.22.4.19.24.4.28.6.8.22
5187
4.13.22.11.9.13.27.15.7
5190
4.14.16.14.1.8.1.22.17.10
5191
4.14.17.12.20.17.1.22.3
5193
4.15.20.23.12.16.2.16.17
5197
4.19.16.15.5.2.25.8.28.14.2
5198
4.2.16.13.16.11.19.10.10.25
5201
4.21.28.5.16.29.5.21
5202
4.21.9.1.2.14.8.17.13.26
5204
4.22.17.10.19.9.8.19.28.3.9
5206
4.25.12.10.15.9.18.9
5208
4.26.23.6.19.31.10.4.22
5209
4.26.5.26.21.28.17.24.25.23
5211
4.3.20.27.9.1.18.30.12.5.19
5213
4.30.8.20.19.9.30.24.11
5215
4.5.9.4.15.19.8.26.17.26.3
5223
5.13.23.19.28.26.27.6.1.22
5225
5.14.27.15.11.17.3.10.27.25
5226
5.14.29.2.23.16.20.22
5227
5.15.10.3.23.13.32.23
5231
5.2.32.19.13.29.12.13.31.29
5233
5.21.27.13.14.11.2.16.20
5237
5.24.4.31.3.16.25.17.13.26.11
5240
5.27.28.26.14.15.6.20.1.31.13
5241
5.27.32.21.5.1.11.14
5244
5.31.8.1.5.13.21.28.29.19.2
5245
5.4.8.25.12.27.2.29.28.3
5246
5.5.12.31.23.13.17.22.20
5248
5.8.17.30.15.8.19.29.30.11.6
5252
6.11.11.5.16.8.14.12.9
5253
6.11.31.23.12.8.30.14.27
5256
6.17.10.10.7.9.27.8.29
5257
6.17.26.25.27.11.10.9
5259
6.19.29.11.2.32.21.15.32.9
5261
6.19.6.4.9.11.32.17.17.3.15
5269
6.26.29.10.21.28.20.19
5271
6.27.29.14.8.12.26.3.21.4.1
5273
6.29.6.13.14.24.10.4.14.28
5274
6.5.27.19.13.26.1.18.9
5276
6.7.25.16.13.21.7.20.25.12.4
5281
7.10.17.21.11.29.17.25.19.4.29
5284
7.12.1.10.6.17.29.24.24.4
5288
7.14.22.29.30.14.25.1.9.26.25
5290
7.19.10.12.31.1.27.13.19
5291
7.19.12.3.21.19.18.5.2.14.10
5292
7.19.6.17.15.26.21.9
5294
7.23.1.24.29.13.31.19.23.17.7
5295
7.23.15.32.28.27.2.2.26
5298
7.30.19.25.23.15.14.29
5299
7.30.5.10.10.5.30.14.9.18
5301
7.31.2.28.15.11.17.18.19.23.6
5304
7.5.28.8.17.26.31.10.15
5306
7.7.22.24.17.32.17.25.28
5313
8.13.14.11.11.29.22.4.4.10
5315
8.13.9.31.20.20.24.7.23.31.28
5318
8.16.1.16.28.6.3.22.6.23
5319
8.16.20.24.20.6.10.21
5320
8.16.30.29.19.22.28.24.2
5323
8.17.9.15.21.28.1.7.1.3.6
5328
8.22.32.17.16.28.31.23.22.9
5330
8.25.20.3.15.24.7.4.24.5.30
5331
8.26.29.13.7.25.31.28.3.32
5334
8.3.18.13.30.20.27.26.17.28
5335
8.3.3.25.25.15.7.13.21.18
5338
8.5.24.9.29.32.31.30.13.9.7
5343
8.9.25.25.26.30.31.31.2.32.7
5344
9.10.19.18.15.11.22.32.32.14.9
5346
9.14.27.31.26.21.25.3.20
5347
9.16.2.16.22.24.17.31.14.21.17
5350
9.18.30.11.29.32.7.19.2
5356
9.21.28.8.12.15.3.13.10.11
5358
9.23.21.22.5.29.15.21
5360
9.28.10.26.14.26.15.14
5364
9.3.31.18.12.3.9.29.10
5366
9.31.23.19.5.10.16.4.30.24.5
5367
9.31.4.14.31.10.17.5.2
5369
9.5.9.3.23.9.25.14.1.29.28
5370
9.6.9.21.6.11.29.13.29.20.32
5377
create index tstidx on ltreetest using gist (t);
5378
set enable_seqscan=off;
5379
SELECT * FROM ltreetest WHERE t < '12.3' order by t asc;
5381
----------------------------------
5397
1.11.10.19.6.1.26.17.2.22
5398
1.12.25.26.22.8.15.23
5399
1.13.16.27.11.16.30.2.9.18.4
5401
1.15.17.6.28.25.24.31.27.9
5402
1.16.8.18.14.16.21.25.6
5403
1.18.29.30.22.14.3.20.15.21.20
5404
1.19.22.11.14.7.32.23.19.14
5405
1.20.18.25.3.24.25.10.9
5410
1.25.7.9.26.17.31.20.13
5412
1.26.15.23.5.31.29.11.19.28.1
5413
1.27.22.23.2.26.32.17.7.9
5414
1.28.19.8.25.6.20.27.29.27
5416
1.29.18.1.21.12.13.27.32.15
5417
1.3.15.11.11.25.24.21.19
5418
1.30.18.31.12.25.4.19.28.12.15
5423
1.9.18.10.1.26.22.16.17
5424
10.11.25.2.24.18.18.21.6.26.21
5425
10.12.23.22.23.22.20.17.17.9
5426
10.12.9.6.6.26.14.8.23.1.25
5427
10.13.12.8.4.8.11.30
5428
10.13.22.1.8.30.9.24.1.2.1
5430
10.16.18.9.27.2.29.32.24.13
5432
10.18.12.27.24.30.32.7.11.5.13
5433
10.2.17.26.16.7.19.6.23.3
5436
10.22.30.16.2.21.17.13
5437
10.26.27.23.4.31.11.25.29
5439
10.27.7.24.26.11.31.20.29
5440
10.28.22.29.13.19.6.7.6.14
5447
10.31.25.31.24.16.17
5449
10.5.23.5.32.9.18.5.30
5454
11.1.3.28.30.21.24.14
5458
11.11.9.30.15.29.15.18
5460
11.14.21.24.10.7.29.23.24.28
5464
11.17.17.24.11.23.17.17.18.10.22
5465
11.18.4.8.3.13.14.28.18.31
5470
11.22.28.8.12.23.25.15.21.28
5474
11.30.20.15.18.32.1.18.25.26.8
5476
11.6.11.29.4.5.24.6.26.12
5482
12.10.11.9.10.31.4.16.31
5485
12.13.16.17.29.27.16.14.9.19.9
5494
12.21.15.27.24.15.8.24.24.26
5497
12.23.3.19.29.15.12.6
5499
12.25.32.2.27.3.3.16
5500
12.27.23.32.1.1.9.29.13
5502
12.28.12.24.28.15.5.12.30.13.21
5503
12.29.17.2.20.29.1.11.19.8.12
5504
12.29.26.18.4.21.28.8.13.3
5507
SELECT * FROM ltreetest WHERE t <= '12.3' order by t asc;
5509
----------------------------------
5525
1.11.10.19.6.1.26.17.2.22
5526
1.12.25.26.22.8.15.23
5527
1.13.16.27.11.16.30.2.9.18.4
5529
1.15.17.6.28.25.24.31.27.9
5530
1.16.8.18.14.16.21.25.6
5531
1.18.29.30.22.14.3.20.15.21.20
5532
1.19.22.11.14.7.32.23.19.14
5533
1.20.18.25.3.24.25.10.9
5538
1.25.7.9.26.17.31.20.13
5540
1.26.15.23.5.31.29.11.19.28.1
5541
1.27.22.23.2.26.32.17.7.9
5542
1.28.19.8.25.6.20.27.29.27
5544
1.29.18.1.21.12.13.27.32.15
5545
1.3.15.11.11.25.24.21.19
5546
1.30.18.31.12.25.4.19.28.12.15
5551
1.9.18.10.1.26.22.16.17
5552
10.11.25.2.24.18.18.21.6.26.21
5553
10.12.23.22.23.22.20.17.17.9
5554
10.12.9.6.6.26.14.8.23.1.25
5555
10.13.12.8.4.8.11.30
5556
10.13.22.1.8.30.9.24.1.2.1
5558
10.16.18.9.27.2.29.32.24.13
5560
10.18.12.27.24.30.32.7.11.5.13
5561
10.2.17.26.16.7.19.6.23.3
5564
10.22.30.16.2.21.17.13
5565
10.26.27.23.4.31.11.25.29
5567
10.27.7.24.26.11.31.20.29
5568
10.28.22.29.13.19.6.7.6.14
5575
10.31.25.31.24.16.17
5577
10.5.23.5.32.9.18.5.30
5582
11.1.3.28.30.21.24.14
5586
11.11.9.30.15.29.15.18
5588
11.14.21.24.10.7.29.23.24.28
5592
11.17.17.24.11.23.17.17.18.10.22
5593
11.18.4.8.3.13.14.28.18.31
5598
11.22.28.8.12.23.25.15.21.28
5602
11.30.20.15.18.32.1.18.25.26.8
5604
11.6.11.29.4.5.24.6.26.12
5610
12.10.11.9.10.31.4.16.31
5613
12.13.16.17.29.27.16.14.9.19.9
5622
12.21.15.27.24.15.8.24.24.26
5625
12.23.3.19.29.15.12.6
5627
12.25.32.2.27.3.3.16
5628
12.27.23.32.1.1.9.29.13
5630
12.28.12.24.28.15.5.12.30.13.21
5631
12.29.17.2.20.29.1.11.19.8.12
5632
12.29.26.18.4.21.28.8.13.3
5636
SELECT * FROM ltreetest WHERE t = '12.3' order by t asc;
5642
SELECT * FROM ltreetest WHERE t >= '12.3' order by t asc;
5644
----------------------------------
5646
12.4.10.17.4.10.23.3
5647
12.4.12.13.25.30.30.8.9.12
5649
12.4.26.23.25.5.15.7.16
5650
12.6.14.23.19.21.9.12
5651
12.7.16.8.21.22.2.16.18
5652
12.7.28.26.14.21.18.31.5.15.11
5653
13.1.6.17.28.9.15.30.1.27.14
5655
13.14.13.10.28.26.9.18.27.21
5656
13.16.1.27.18.18.19.6.14.4
5659
13.19.2.6.23.19.9.7.21.8.16
5669
13.32.15.32.26.14.32
5671
13.8.15.3.7.31.5.10.15.30
5673
13.8.23.13.11.18.24.21.11.24.10
5674
13.9.9.27.31.11.25.9.27.22.13
5676
14.1.15.25.27.23.25.26.28.10
5677
14.10.11.30.5.7.6.24.9.30.26
5680
14.13.9.13.11.5.5.2.2.32.12
5683
14.16.6.29.26.13.14.16.25.26.8
5684
14.17.7.30.8.25.26.4
5687
14.19.30.6.4.10.10.10.22.25.11
5690
14.21.5.28.3.32.24.14.25.31
5691
14.21.6.5.26.9.32.16.25
5692
14.23.31.5.5.15.17.12.17.7.3
5695
14.27.29.23.4.1.17.32.6.25.22
5697
14.3.17.1.14.15.21.4.26
5698
14.30.13.5.26.9.22.23.14.10
5702
14.4.23.4.23.22.11.6.26.5
5703
14.5.13.19.25.12.32.9.13.16.12
5704
14.6.10.29.25.26.20.24.24
5705
14.8.15.30.7.29.27.31.4
5706
14.9.15.21.21.31.1.29
5707
15.1.6.31.30.13.32.9.10
5709
15.10.30.1.4.12.8.20
5710
15.11.26.1.30.6.23.5
5716
15.25.31.11.4.22.16.7.11
5717
15.26.24.31.16.15.17.22.8.30.3
5719
15.28.30.19.31.6.2.2.31
5721
15.29.32.16.29.12.20.32.13.20
5722
15.3.31.9.27.14.9.8.14.6.32
5723
15.30.17.5.32.28.2.18.27
5724
15.31.11.27.19.19.20.5.5
5729
15.7.5.12.7.9.3.28.26
5731
15.8.3.15.27.14.29.28.6.5.25
5732
15.9.11.20.22.15.11.13
5734
16.13.19.11.18.13.17.17
5735
16.13.2.19.14.29.31.30.23.15.12
5736
16.13.26.18.9.29.11.17.1.24.26
5737
16.14.3.17.17.26.12.19.19.30
5740
16.19.17.30.30.5.17.24.27
5744
16.23.30.12.31.31.19.14
5745
16.24.3.30.15.22.31.2
5747
16.27.8.17.14.17.21.29.14
5749
16.29.6.23.13.28.31.6.19.26.15
5750
16.30.10.7.29.4.9.21.22.13.26
5751
16.31.12.27.25.9.32.29
5753
16.5.10.2.18.8.15.12.32.25.10
5754
16.5.12.5.15.12.24.25.3
5755
16.5.14.21.32.17.23.3.4.26
5759
16.9.14.28.6.21.31.31.26
5761
16.9.32.14.3.7.8.7.21.22
5763
17.10.17.22.20.25.14.13
5764
17.11.17.4.8.26.26.20.6
5765
17.13.14.29.27.27.13.12.15
5766
17.13.19.31.12.18.10.15.14
5768
17.14.7.3.2.18.20.23.18.5
5770
17.19.1.22.11.7.22.1.14.28.11
5772
17.24.15.27.3.32.4.22.20.6.24
5774
17.25.10.13.21.5.7.22.2
5775
17.25.2.13.10.27.13.1
5779
17.29.21.10.18.8.16.26.18.21.26
5780
17.29.31.8.24.10.18.27.17
5786
17.9.32.31.21.31.23.17.10.32.9
5787
18.13.6.12.26.26.26.29.18.20.1
5791
18.18.19.16.14.16.21.10.25
5793
18.19.11.20.13.13.11
5794
18.19.12.20.18.17.15.32.18.5
5796
18.24.21.17.11.26.28.22.21.18.10
5797
18.27.11.27.9.16.7.6.22.26.27
5798
18.29.13.24.18.3.12.18.12.12
5802
18.31.26.18.6.15.18.11
5803
18.31.32.28.1.4.24.24.12.25
5804
18.31.32.29.22.1.31.11.28
5809
18.6.26.2.13.9.6.11.10.11.16
5811
18.7.3.17.13.5.31.6.31.25.29
5814
19.10.26.19.5.21.30.23
5817
19.11.10.18.14.13.7.7
5818
19.11.29.13.15.27.12.15.14.12
5819
19.12.20.24.32.13.11.23.26
5827
19.19.25.22.11.6.15.3.2.19
5828
19.2.26.21.16.11.2.2
5830
19.20.25.7.27.28.27.17.9.3.1
5831
19.22.21.13.27.13.15
5832
19.22.29.32.1.21.26.24.23.17
5833
19.26.24.27.6.24.16.27.32.29
5834
19.26.32.13.1.12.30.26.22.25
5839
19.31.14.25.5.8.21.11.13.20
5841
19.6.13.14.22.13.9.29
5842
19.6.24.32.30.13.6.25.8.28
5844
19.7.29.31.3.20.7.21.25.27.29
5846
2.1.12.19.29.28.3.31.28.28.10
5848
2.10.10.4.20.1.12.13
5849
2.10.28.1.17.19.32.28
5855
2.14.10.4.17.17.8.4.27.20
5858
2.15.18.21.5.21.4.7.30
5859
2.16.3.7.22.18.29.20
5860
2.19.4.1.15.7.8.9.17.29
5861
2.2.18.18.3.3.18.8.10.8
5864
2.24.5.3.4.10.27.26.17.28.16
5867
2.30.26.10.14.31.18.2
5870
2.32.8.28.24.20.9.24.25.8.9
5871
2.4.25.32.16.22.26.13.17.18
5873
2.8.13.12.17.23.16.7.11.23
5882
20.20.32.29.24.5.5.26.22.32
5885
20.23.29.5.7.30.13.14.22
5886
20.23.7.11.11.31.18.16.3
5887
20.24.14.15.4.21.12.27.4.12
5889
20.28.22.7.10.28.27.22.14.16
5890
20.29.18.16.2.21.23.11
5895
20.31.13.12.19.2.26.16.16.22.28
5896
20.32.5.1.3.20.3.30.27
5905
21.1.4.9.9.31.24.21.3.29
5906
21.10.20.9.3.16.9.10.20
5910
21.14.25.20.13.31.14.20
5912
21.15.31.24.29.24.26.12.20
5915
21.17.31.10.31.13.9.26.6.14
5924
21.23.17.8.23.11.8.1
5925
21.28.17.22.10.27.4.20.2.32
5926
21.28.24.23.3.11.7.12.22.32
5927
21.30.19.6.28.1.32.2.14.14
5930
21.32.13.22.3.13.31.23.14.12.9
5934
21.5.17.19.15.25.18.21.24.9
5935
21.6.22.28.12.23.11.22
5936
21.7.23.9.16.5.18.14
5944
22.10.27.19.29.20.29.3.12.14.25
5948
22.13.22.8.30.32.10.24
5951
22.16.25.18.25.7.24.29.14.8
5952
22.17.24.14.21.15.12.18.17.25.11
5956
22.17.9.11.25.15.3.9
5959
22.19.21.11.6.8.29.24
5960
22.19.5.22.20.31.23.24.14.24.4
5962
22.21.32.15.8.29.5.12.10.29
5963
22.22.10.30.5.15.25.21.19.11
5964
22.22.27.6.27.15.5.18.21.28.9
5965
22.23.18.18.9.8.23.7.23.23.16
5967
22.23.25.28.5.27.9.9.24.31.10
5968
22.24.22.25.15.23.13
5969
22.25.4.28.9.20.12.13
5973
22.29.18.32.13.12.22.31.17.22
5977
22.30.31.24.23.22.5.20.28.1
5978
22.31.2.32.32.11.26.23.19
5979
22.31.21.13.13.26.11.5.19
5980
22.32.6.6.3.8.24.6.25.29
5981
22.8.20.1.10.28.6.27
5984
23.10.13.32.14.20.16.11.14
5985
23.10.5.26.12.4.20.4
5986
23.12.1.5.32.25.8.24.1.25
5987
23.12.11.11.15.16.22.31.32.5.8
5988
23.12.19.25.16.23.22.6.29.4
5989
23.12.32.22.19.1.22.4
5990
23.14.12.30.18.4.16.18.7.7
5991
23.14.30.27.28.26.26.23.8.32
5992
23.17.22.1.23.4.29.32.4.1
5993
23.17.25.4.1.16.29.10
5995
23.17.32.15.23.16.25
5996
23.19.17.31.29.13.1.12.5.25
6004
23.24.11.31.10.31.18.28.13.18.6
6010
23.28.20.25.30.24.15
6011
23.28.3.30.15.31.32.3.21.9.19
6013
23.3.32.21.5.14.10.17.1
6014
23.31.27.16.8.30.20.27
6015
23.32.5.25.19.9.15.17.15.11
6020
24.1.10.20.28.18.6.27.20.30.26
6021
24.1.29.32.14.15.32.6.15.22
6030
24.17.31.20.12.9.19.29.18
6032
24.2.26.24.14.15.31.23.17.26
6035
24.21.14.25.11.3.20.6.6.16
6037
24.23.29.8.24.11.21.10.28.14.27
6039
24.25.7.27.30.8.26.17
6041
24.27.18.32.14.9.11.28.9
6046
24.31.2.13.5.23.18.16
6048
24.32.17.23.24.19.23.9.20.18
6055
25.10.29.3.6.21.3.31.13
6063
25.17.2.20.20.3.29.21.3.12
6064
25.17.9.16.17.31.23.29.24
6065
25.18.8.3.23.23.5.9.6
6068
25.2.3.15.11.19.5.28.25.14
6079
25.32.24.24.28.15.16.10
6081
25.4.4.1.13.32.26.20.20.3
6082
25.5.30.7.16.12.21.12.11.16
6087
25.9.1.5.9.11.25.4.11.27.32
6096
26.17.9.13.4.25.32.2.24.9
6099
26.19.3.14.8.28.31.10
6101
26.24.9.12.11.15.31.2
6104
26.26.22.21.14.11.29.19.14.24
6107
26.31.16.18.22.13.32.23.9.20
6111
26.32.8.12.30.19.24.8.6.1.10
6114
26.7.5.8.11.9.22.1.6
6116
26.9.17.1.18.19.1.11.18.29.3
6120
27.11.15.9.24.31.18.4.1.30.20
6125
27.17.17.19.24.9.14.20
6129
27.19.20.1.31.29.5.22.26.3
6130
27.2.10.4.25.14.2.15.4
6132
27.21.28.24.7.2.24.23.8
6133
27.22.11.13.21.25.5.1.27.21.27
6136
27.24.11.31.21.6.29.17.24.18
6140
27.27.25.10.31.10.21.22.21.16.12
6141
27.27.30.11.15.24.9.7.4.30
6142
27.29.1.5.30.6.22.16.23.2.28
6145
27.30.12.11.20.15.11.13
6147
27.32.26.21.31.17.32.32
6150
27.4.17.17.32.8.16.15.17.13
6153
27.6.13.24.21.27.28.22.3.7.4
6155
28.11.11.30.20.11.32
6157
28.14.24.26.6.15.16.32.25.13.8
6160
28.15.25.7.13.6.19.2
6164
28.20.8.9.9.28.30.29
6165
28.23.2.30.3.8.1.15.15.14.13
6171
28.26.4.22.13.20.32.27.15
6174
28.30.24.16.17.28.2.13.10
6175
28.31.10.28.22.26.16.15
6177
28.5.12.9.2.27.11.11.2
6180
28.6.11.6.15.22.12.6
6182
28.8.21.15.16.28.4.16.26.8
6183
28.9.3.16.17.21.23.30
6188
29.10.17.11.28.12.18.5.19.15.21
6193
29.20.1.11.21.16.1.2.14.28
6195
29.23.15.25.1.6.6.10
6196
29.25.29.16.32.11.15.25.5.22.3
6197
29.25.30.15.21.3.25.26.26
6198
29.26.25.14.24.18.2.13.23.29
6201
29.27.13.9.28.29.19.13.29.31.27
6203
29.27.7.7.3.11.14.26.21.11
6212
29.5.18.27.3.21.18.6.14
6213
29.5.32.20.11.7.13.24.17
6214
29.6.12.31.20.23.32.20
6215
29.9.25.27.15.16.32.26.6.32
6216
3.1.13.22.24.14.12.31.3.4
6217
3.1.14.8.9.16.30.22.20
6219
3.10.27.4.5.6.19.12.28.12
6222
3.11.32.11.22.3.7.17.8.13.23
6224
3.14.1.14.17.28.29.16
6225
3.14.11.15.21.32.2.15.13
6227
3.15.2.23.22.2.16.14
6230
3.18.8.22.7.28.32.31.3
6233
3.20.19.10.17.27.3.6.22.23
6234
3.21.16.24.23.12.16.32.3
6236
3.22.18.1.5.14.9.6.14
6240
3.27.18.8.4.21.6.32.30.7.5
6244
3.32.2.29.3.32.28.11.29.30
6247
3.6.24.21.20.32.3.4.26.5
6248
3.9.11.23.32.26.24.28
6252
30.12.9.25.24.6.7.24.29
6254
30.16.14.9.5.4.10.7.31
6257
30.17.25.3.31.11.3.4.1.10
6261
30.20.3.2.5.15.8.7.17
6262
30.22.29.21.19.14.3.2.6
6263
30.23.10.1.10.7.22.28.18.11.17
6264
30.23.2.13.14.15.29.19.4.12.24
6266
30.24.23.25.32.18.22.12.29.9.22
6267
30.24.32.15.14.10.11
6273
30.3.16.26.7.27.26.9.27.21.18
6274
30.30.17.5.30.21.19.5.22.22.14
6277
30.4.30.11.13.23.14.24.11
6288
31.18.25.1.14.29.25.5.22.30
6289
31.18.27.15.20.29.29
6290
31.18.32.11.7.25.20.5
6291
31.21.14.20.1.22.2.5.3.27.12
6296
31.29.4.29.24.30.30.32.10.23
6298
31.30.23.7.7.24.32.10.11.1.31
6299
31.32.12.26.31.32.14.23.28
6305
32.1.23.20.14.12.23.5.32.15
6306
32.1.24.29.22.5.9.24.18.3.13
6308
32.15.20.28.5.1.23.4
6310
32.17.8.24.2.14.5.4.22
6311
32.19.20.24.23.31.8.32.16.29
6313
32.24.11.8.12.23.22.19.11.17.18
6324
32.30.18.17.1.14.12.18
6326
32.31.26.19.13.29.4.25
6329
32.6.15.26.14.15.3.19
6330
32.6.3.2.12.5.28.1.25
6333
32.6.9.26.16.4.4.29.7.11
6338
4.11.19.17.2.22.20.18.13.32.15
6339
4.11.22.4.19.24.4.28.6.8.22
6341
4.13.22.11.9.13.27.15.7
6344
4.14.16.14.1.8.1.22.17.10
6345
4.14.17.12.20.17.1.22.3
6347
4.15.20.23.12.16.2.16.17
6351
4.19.16.15.5.2.25.8.28.14.2
6352
4.2.16.13.16.11.19.10.10.25
6355
4.21.28.5.16.29.5.21
6356
4.21.9.1.2.14.8.17.13.26
6358
4.22.17.10.19.9.8.19.28.3.9
6360
4.25.12.10.15.9.18.9
6362
4.26.23.6.19.31.10.4.22
6363
4.26.5.26.21.28.17.24.25.23
6365
4.3.20.27.9.1.18.30.12.5.19
6367
4.30.8.20.19.9.30.24.11
6369
4.5.9.4.15.19.8.26.17.26.3
6377
5.13.23.19.28.26.27.6.1.22
6379
5.14.27.15.11.17.3.10.27.25
6380
5.14.29.2.23.16.20.22
6381
5.15.10.3.23.13.32.23
6385
5.2.32.19.13.29.12.13.31.29
6387
5.21.27.13.14.11.2.16.20
6391
5.24.4.31.3.16.25.17.13.26.11
6394
5.27.28.26.14.15.6.20.1.31.13
6395
5.27.32.21.5.1.11.14
6398
5.31.8.1.5.13.21.28.29.19.2
6399
5.4.8.25.12.27.2.29.28.3
6400
5.5.12.31.23.13.17.22.20
6402
5.8.17.30.15.8.19.29.30.11.6
6406
6.11.11.5.16.8.14.12.9
6407
6.11.31.23.12.8.30.14.27
6410
6.17.10.10.7.9.27.8.29
6411
6.17.26.25.27.11.10.9
6413
6.19.29.11.2.32.21.15.32.9
6415
6.19.6.4.9.11.32.17.17.3.15
6423
6.26.29.10.21.28.20.19
6425
6.27.29.14.8.12.26.3.21.4.1
6427
6.29.6.13.14.24.10.4.14.28
6428
6.5.27.19.13.26.1.18.9
6430
6.7.25.16.13.21.7.20.25.12.4
6435
7.10.17.21.11.29.17.25.19.4.29
6438
7.12.1.10.6.17.29.24.24.4
6442
7.14.22.29.30.14.25.1.9.26.25
6444
7.19.10.12.31.1.27.13.19
6445
7.19.12.3.21.19.18.5.2.14.10
6446
7.19.6.17.15.26.21.9
6448
7.23.1.24.29.13.31.19.23.17.7
6449
7.23.15.32.28.27.2.2.26
6452
7.30.19.25.23.15.14.29
6453
7.30.5.10.10.5.30.14.9.18
6455
7.31.2.28.15.11.17.18.19.23.6
6458
7.5.28.8.17.26.31.10.15
6460
7.7.22.24.17.32.17.25.28
6467
8.13.14.11.11.29.22.4.4.10
6469
8.13.9.31.20.20.24.7.23.31.28
6472
8.16.1.16.28.6.3.22.6.23
6473
8.16.20.24.20.6.10.21
6474
8.16.30.29.19.22.28.24.2
6477
8.17.9.15.21.28.1.7.1.3.6
6482
8.22.32.17.16.28.31.23.22.9
6484
8.25.20.3.15.24.7.4.24.5.30
6485
8.26.29.13.7.25.31.28.3.32
6488
8.3.18.13.30.20.27.26.17.28
6489
8.3.3.25.25.15.7.13.21.18
6492
8.5.24.9.29.32.31.30.13.9.7
6497
8.9.25.25.26.30.31.31.2.32.7
6498
9.10.19.18.15.11.22.32.32.14.9
6500
9.14.27.31.26.21.25.3.20
6501
9.16.2.16.22.24.17.31.14.21.17
6504
9.18.30.11.29.32.7.19.2
6510
9.21.28.8.12.15.3.13.10.11
6512
9.23.21.22.5.29.15.21
6514
9.28.10.26.14.26.15.14
6518
9.3.31.18.12.3.9.29.10
6520
9.31.23.19.5.10.16.4.30.24.5
6521
9.31.4.14.31.10.17.5.2
6523
9.5.9.3.23.9.25.14.1.29.28
6524
9.6.9.21.6.11.29.13.29.20.32
6530
SELECT * FROM ltreetest WHERE t > '12.3' order by t asc;
6532
----------------------------------
6533
12.4.10.17.4.10.23.3
6534
12.4.12.13.25.30.30.8.9.12
6536
12.4.26.23.25.5.15.7.16
6537
12.6.14.23.19.21.9.12
6538
12.7.16.8.21.22.2.16.18
6539
12.7.28.26.14.21.18.31.5.15.11
6540
13.1.6.17.28.9.15.30.1.27.14
6542
13.14.13.10.28.26.9.18.27.21
6543
13.16.1.27.18.18.19.6.14.4
6546
13.19.2.6.23.19.9.7.21.8.16
6556
13.32.15.32.26.14.32
6558
13.8.15.3.7.31.5.10.15.30
6560
13.8.23.13.11.18.24.21.11.24.10
6561
13.9.9.27.31.11.25.9.27.22.13
6563
14.1.15.25.27.23.25.26.28.10
6564
14.10.11.30.5.7.6.24.9.30.26
6567
14.13.9.13.11.5.5.2.2.32.12
6570
14.16.6.29.26.13.14.16.25.26.8
6571
14.17.7.30.8.25.26.4
6574
14.19.30.6.4.10.10.10.22.25.11
6577
14.21.5.28.3.32.24.14.25.31
6578
14.21.6.5.26.9.32.16.25
6579
14.23.31.5.5.15.17.12.17.7.3
6582
14.27.29.23.4.1.17.32.6.25.22
6584
14.3.17.1.14.15.21.4.26
6585
14.30.13.5.26.9.22.23.14.10
6589
14.4.23.4.23.22.11.6.26.5
6590
14.5.13.19.25.12.32.9.13.16.12
6591
14.6.10.29.25.26.20.24.24
6592
14.8.15.30.7.29.27.31.4
6593
14.9.15.21.21.31.1.29
6594
15.1.6.31.30.13.32.9.10
6596
15.10.30.1.4.12.8.20
6597
15.11.26.1.30.6.23.5
6603
15.25.31.11.4.22.16.7.11
6604
15.26.24.31.16.15.17.22.8.30.3
6606
15.28.30.19.31.6.2.2.31
6608
15.29.32.16.29.12.20.32.13.20
6609
15.3.31.9.27.14.9.8.14.6.32
6610
15.30.17.5.32.28.2.18.27
6611
15.31.11.27.19.19.20.5.5
6616
15.7.5.12.7.9.3.28.26
6618
15.8.3.15.27.14.29.28.6.5.25
6619
15.9.11.20.22.15.11.13
6621
16.13.19.11.18.13.17.17
6622
16.13.2.19.14.29.31.30.23.15.12
6623
16.13.26.18.9.29.11.17.1.24.26
6624
16.14.3.17.17.26.12.19.19.30
6627
16.19.17.30.30.5.17.24.27
6631
16.23.30.12.31.31.19.14
6632
16.24.3.30.15.22.31.2
6634
16.27.8.17.14.17.21.29.14
6636
16.29.6.23.13.28.31.6.19.26.15
6637
16.30.10.7.29.4.9.21.22.13.26
6638
16.31.12.27.25.9.32.29
6640
16.5.10.2.18.8.15.12.32.25.10
6641
16.5.12.5.15.12.24.25.3
6642
16.5.14.21.32.17.23.3.4.26
6646
16.9.14.28.6.21.31.31.26
6648
16.9.32.14.3.7.8.7.21.22
6650
17.10.17.22.20.25.14.13
6651
17.11.17.4.8.26.26.20.6
6652
17.13.14.29.27.27.13.12.15
6653
17.13.19.31.12.18.10.15.14
6655
17.14.7.3.2.18.20.23.18.5
6657
17.19.1.22.11.7.22.1.14.28.11
6659
17.24.15.27.3.32.4.22.20.6.24
6661
17.25.10.13.21.5.7.22.2
6662
17.25.2.13.10.27.13.1
6666
17.29.21.10.18.8.16.26.18.21.26
6667
17.29.31.8.24.10.18.27.17
6673
17.9.32.31.21.31.23.17.10.32.9
6674
18.13.6.12.26.26.26.29.18.20.1
6678
18.18.19.16.14.16.21.10.25
6680
18.19.11.20.13.13.11
6681
18.19.12.20.18.17.15.32.18.5
6683
18.24.21.17.11.26.28.22.21.18.10
6684
18.27.11.27.9.16.7.6.22.26.27
6685
18.29.13.24.18.3.12.18.12.12
6689
18.31.26.18.6.15.18.11
6690
18.31.32.28.1.4.24.24.12.25
6691
18.31.32.29.22.1.31.11.28
6696
18.6.26.2.13.9.6.11.10.11.16
6698
18.7.3.17.13.5.31.6.31.25.29
6701
19.10.26.19.5.21.30.23
6704
19.11.10.18.14.13.7.7
6705
19.11.29.13.15.27.12.15.14.12
6706
19.12.20.24.32.13.11.23.26
6714
19.19.25.22.11.6.15.3.2.19
6715
19.2.26.21.16.11.2.2
6717
19.20.25.7.27.28.27.17.9.3.1
6718
19.22.21.13.27.13.15
6719
19.22.29.32.1.21.26.24.23.17
6720
19.26.24.27.6.24.16.27.32.29
6721
19.26.32.13.1.12.30.26.22.25
6726
19.31.14.25.5.8.21.11.13.20
6728
19.6.13.14.22.13.9.29
6729
19.6.24.32.30.13.6.25.8.28
6731
19.7.29.31.3.20.7.21.25.27.29
6733
2.1.12.19.29.28.3.31.28.28.10
6735
2.10.10.4.20.1.12.13
6736
2.10.28.1.17.19.32.28
6742
2.14.10.4.17.17.8.4.27.20
6745
2.15.18.21.5.21.4.7.30
6746
2.16.3.7.22.18.29.20
6747
2.19.4.1.15.7.8.9.17.29
6748
2.2.18.18.3.3.18.8.10.8
6751
2.24.5.3.4.10.27.26.17.28.16
6754
2.30.26.10.14.31.18.2
6757
2.32.8.28.24.20.9.24.25.8.9
6758
2.4.25.32.16.22.26.13.17.18
6760
2.8.13.12.17.23.16.7.11.23
6769
20.20.32.29.24.5.5.26.22.32
6772
20.23.29.5.7.30.13.14.22
6773
20.23.7.11.11.31.18.16.3
6774
20.24.14.15.4.21.12.27.4.12
6776
20.28.22.7.10.28.27.22.14.16
6777
20.29.18.16.2.21.23.11
6782
20.31.13.12.19.2.26.16.16.22.28
6783
20.32.5.1.3.20.3.30.27
6792
21.1.4.9.9.31.24.21.3.29
6793
21.10.20.9.3.16.9.10.20
6797
21.14.25.20.13.31.14.20
6799
21.15.31.24.29.24.26.12.20
6802
21.17.31.10.31.13.9.26.6.14
6811
21.23.17.8.23.11.8.1
6812
21.28.17.22.10.27.4.20.2.32
6813
21.28.24.23.3.11.7.12.22.32
6814
21.30.19.6.28.1.32.2.14.14
6817
21.32.13.22.3.13.31.23.14.12.9
6821
21.5.17.19.15.25.18.21.24.9
6822
21.6.22.28.12.23.11.22
6823
21.7.23.9.16.5.18.14
6831
22.10.27.19.29.20.29.3.12.14.25
6835
22.13.22.8.30.32.10.24
6838
22.16.25.18.25.7.24.29.14.8
6839
22.17.24.14.21.15.12.18.17.25.11
6843
22.17.9.11.25.15.3.9
6846
22.19.21.11.6.8.29.24
6847
22.19.5.22.20.31.23.24.14.24.4
6849
22.21.32.15.8.29.5.12.10.29
6850
22.22.10.30.5.15.25.21.19.11
6851
22.22.27.6.27.15.5.18.21.28.9
6852
22.23.18.18.9.8.23.7.23.23.16
6854
22.23.25.28.5.27.9.9.24.31.10
6855
22.24.22.25.15.23.13
6856
22.25.4.28.9.20.12.13
6860
22.29.18.32.13.12.22.31.17.22
6864
22.30.31.24.23.22.5.20.28.1
6865
22.31.2.32.32.11.26.23.19
6866
22.31.21.13.13.26.11.5.19
6867
22.32.6.6.3.8.24.6.25.29
6868
22.8.20.1.10.28.6.27
6871
23.10.13.32.14.20.16.11.14
6872
23.10.5.26.12.4.20.4
6873
23.12.1.5.32.25.8.24.1.25
6874
23.12.11.11.15.16.22.31.32.5.8
6875
23.12.19.25.16.23.22.6.29.4
6876
23.12.32.22.19.1.22.4
6877
23.14.12.30.18.4.16.18.7.7
6878
23.14.30.27.28.26.26.23.8.32
6879
23.17.22.1.23.4.29.32.4.1
6880
23.17.25.4.1.16.29.10
6882
23.17.32.15.23.16.25
6883
23.19.17.31.29.13.1.12.5.25
6891
23.24.11.31.10.31.18.28.13.18.6
6897
23.28.20.25.30.24.15
6898
23.28.3.30.15.31.32.3.21.9.19
6900
23.3.32.21.5.14.10.17.1
6901
23.31.27.16.8.30.20.27
6902
23.32.5.25.19.9.15.17.15.11
6907
24.1.10.20.28.18.6.27.20.30.26
6908
24.1.29.32.14.15.32.6.15.22
6917
24.17.31.20.12.9.19.29.18
6919
24.2.26.24.14.15.31.23.17.26
6922
24.21.14.25.11.3.20.6.6.16
6924
24.23.29.8.24.11.21.10.28.14.27
6926
24.25.7.27.30.8.26.17
6928
24.27.18.32.14.9.11.28.9
6933
24.31.2.13.5.23.18.16
6935
24.32.17.23.24.19.23.9.20.18
6942
25.10.29.3.6.21.3.31.13
6950
25.17.2.20.20.3.29.21.3.12
6951
25.17.9.16.17.31.23.29.24
6952
25.18.8.3.23.23.5.9.6
6955
25.2.3.15.11.19.5.28.25.14
6966
25.32.24.24.28.15.16.10
6968
25.4.4.1.13.32.26.20.20.3
6969
25.5.30.7.16.12.21.12.11.16
6974
25.9.1.5.9.11.25.4.11.27.32
6983
26.17.9.13.4.25.32.2.24.9
6986
26.19.3.14.8.28.31.10
6988
26.24.9.12.11.15.31.2
6991
26.26.22.21.14.11.29.19.14.24
6994
26.31.16.18.22.13.32.23.9.20
6998
26.32.8.12.30.19.24.8.6.1.10
7001
26.7.5.8.11.9.22.1.6
7003
26.9.17.1.18.19.1.11.18.29.3
7007
27.11.15.9.24.31.18.4.1.30.20
7012
27.17.17.19.24.9.14.20
7016
27.19.20.1.31.29.5.22.26.3
7017
27.2.10.4.25.14.2.15.4
7019
27.21.28.24.7.2.24.23.8
7020
27.22.11.13.21.25.5.1.27.21.27
7023
27.24.11.31.21.6.29.17.24.18
7027
27.27.25.10.31.10.21.22.21.16.12
7028
27.27.30.11.15.24.9.7.4.30
7029
27.29.1.5.30.6.22.16.23.2.28
7032
27.30.12.11.20.15.11.13
7034
27.32.26.21.31.17.32.32
7037
27.4.17.17.32.8.16.15.17.13
7040
27.6.13.24.21.27.28.22.3.7.4
7042
28.11.11.30.20.11.32
7044
28.14.24.26.6.15.16.32.25.13.8
7047
28.15.25.7.13.6.19.2
7051
28.20.8.9.9.28.30.29
7052
28.23.2.30.3.8.1.15.15.14.13
7058
28.26.4.22.13.20.32.27.15
7061
28.30.24.16.17.28.2.13.10
7062
28.31.10.28.22.26.16.15
7064
28.5.12.9.2.27.11.11.2
7067
28.6.11.6.15.22.12.6
7069
28.8.21.15.16.28.4.16.26.8
7070
28.9.3.16.17.21.23.30
7075
29.10.17.11.28.12.18.5.19.15.21
7080
29.20.1.11.21.16.1.2.14.28
7082
29.23.15.25.1.6.6.10
7083
29.25.29.16.32.11.15.25.5.22.3
7084
29.25.30.15.21.3.25.26.26
7085
29.26.25.14.24.18.2.13.23.29
7088
29.27.13.9.28.29.19.13.29.31.27
7090
29.27.7.7.3.11.14.26.21.11
7099
29.5.18.27.3.21.18.6.14
7100
29.5.32.20.11.7.13.24.17
7101
29.6.12.31.20.23.32.20
7102
29.9.25.27.15.16.32.26.6.32
7103
3.1.13.22.24.14.12.31.3.4
7104
3.1.14.8.9.16.30.22.20
7106
3.10.27.4.5.6.19.12.28.12
7109
3.11.32.11.22.3.7.17.8.13.23
7111
3.14.1.14.17.28.29.16
7112
3.14.11.15.21.32.2.15.13
7114
3.15.2.23.22.2.16.14
7117
3.18.8.22.7.28.32.31.3
7120
3.20.19.10.17.27.3.6.22.23
7121
3.21.16.24.23.12.16.32.3
7123
3.22.18.1.5.14.9.6.14
7127
3.27.18.8.4.21.6.32.30.7.5
7131
3.32.2.29.3.32.28.11.29.30
7134
3.6.24.21.20.32.3.4.26.5
7135
3.9.11.23.32.26.24.28
7139
30.12.9.25.24.6.7.24.29
7141
30.16.14.9.5.4.10.7.31
7144
30.17.25.3.31.11.3.4.1.10
7148
30.20.3.2.5.15.8.7.17
7149
30.22.29.21.19.14.3.2.6
7150
30.23.10.1.10.7.22.28.18.11.17
7151
30.23.2.13.14.15.29.19.4.12.24
7153
30.24.23.25.32.18.22.12.29.9.22
7154
30.24.32.15.14.10.11
7160
30.3.16.26.7.27.26.9.27.21.18
7161
30.30.17.5.30.21.19.5.22.22.14
7164
30.4.30.11.13.23.14.24.11
7175
31.18.25.1.14.29.25.5.22.30
7176
31.18.27.15.20.29.29
7177
31.18.32.11.7.25.20.5
7178
31.21.14.20.1.22.2.5.3.27.12
7183
31.29.4.29.24.30.30.32.10.23
7185
31.30.23.7.7.24.32.10.11.1.31
7186
31.32.12.26.31.32.14.23.28
7192
32.1.23.20.14.12.23.5.32.15
7193
32.1.24.29.22.5.9.24.18.3.13
7195
32.15.20.28.5.1.23.4
7197
32.17.8.24.2.14.5.4.22
7198
32.19.20.24.23.31.8.32.16.29
7200
32.24.11.8.12.23.22.19.11.17.18
7211
32.30.18.17.1.14.12.18
7213
32.31.26.19.13.29.4.25
7216
32.6.15.26.14.15.3.19
7217
32.6.3.2.12.5.28.1.25
7220
32.6.9.26.16.4.4.29.7.11
7225
4.11.19.17.2.22.20.18.13.32.15
7226
4.11.22.4.19.24.4.28.6.8.22
7228
4.13.22.11.9.13.27.15.7
7231
4.14.16.14.1.8.1.22.17.10
7232
4.14.17.12.20.17.1.22.3
7234
4.15.20.23.12.16.2.16.17
7238
4.19.16.15.5.2.25.8.28.14.2
7239
4.2.16.13.16.11.19.10.10.25
7242
4.21.28.5.16.29.5.21
7243
4.21.9.1.2.14.8.17.13.26
7245
4.22.17.10.19.9.8.19.28.3.9
7247
4.25.12.10.15.9.18.9
7249
4.26.23.6.19.31.10.4.22
7250
4.26.5.26.21.28.17.24.25.23
7252
4.3.20.27.9.1.18.30.12.5.19
7254
4.30.8.20.19.9.30.24.11
7256
4.5.9.4.15.19.8.26.17.26.3
7264
5.13.23.19.28.26.27.6.1.22
7266
5.14.27.15.11.17.3.10.27.25
7267
5.14.29.2.23.16.20.22
7268
5.15.10.3.23.13.32.23
7272
5.2.32.19.13.29.12.13.31.29
7274
5.21.27.13.14.11.2.16.20
7278
5.24.4.31.3.16.25.17.13.26.11
7281
5.27.28.26.14.15.6.20.1.31.13
7282
5.27.32.21.5.1.11.14
7285
5.31.8.1.5.13.21.28.29.19.2
7286
5.4.8.25.12.27.2.29.28.3
7287
5.5.12.31.23.13.17.22.20
7289
5.8.17.30.15.8.19.29.30.11.6
7293
6.11.11.5.16.8.14.12.9
7294
6.11.31.23.12.8.30.14.27
7297
6.17.10.10.7.9.27.8.29
7298
6.17.26.25.27.11.10.9
7300
6.19.29.11.2.32.21.15.32.9
7302
6.19.6.4.9.11.32.17.17.3.15
7310
6.26.29.10.21.28.20.19
7312
6.27.29.14.8.12.26.3.21.4.1
7314
6.29.6.13.14.24.10.4.14.28
7315
6.5.27.19.13.26.1.18.9
7317
6.7.25.16.13.21.7.20.25.12.4
7322
7.10.17.21.11.29.17.25.19.4.29
7325
7.12.1.10.6.17.29.24.24.4
7329
7.14.22.29.30.14.25.1.9.26.25
7331
7.19.10.12.31.1.27.13.19
7332
7.19.12.3.21.19.18.5.2.14.10
7333
7.19.6.17.15.26.21.9
7335
7.23.1.24.29.13.31.19.23.17.7
7336
7.23.15.32.28.27.2.2.26
7339
7.30.19.25.23.15.14.29
7340
7.30.5.10.10.5.30.14.9.18
7342
7.31.2.28.15.11.17.18.19.23.6
7345
7.5.28.8.17.26.31.10.15
7347
7.7.22.24.17.32.17.25.28
7354
8.13.14.11.11.29.22.4.4.10
7356
8.13.9.31.20.20.24.7.23.31.28
7359
8.16.1.16.28.6.3.22.6.23
7360
8.16.20.24.20.6.10.21
7361
8.16.30.29.19.22.28.24.2
7364
8.17.9.15.21.28.1.7.1.3.6
7369
8.22.32.17.16.28.31.23.22.9
7371
8.25.20.3.15.24.7.4.24.5.30
7372
8.26.29.13.7.25.31.28.3.32
7375
8.3.18.13.30.20.27.26.17.28
7376
8.3.3.25.25.15.7.13.21.18
7379
8.5.24.9.29.32.31.30.13.9.7
7384
8.9.25.25.26.30.31.31.2.32.7
7385
9.10.19.18.15.11.22.32.32.14.9
7387
9.14.27.31.26.21.25.3.20
7388
9.16.2.16.22.24.17.31.14.21.17
7391
9.18.30.11.29.32.7.19.2
7397
9.21.28.8.12.15.3.13.10.11
7399
9.23.21.22.5.29.15.21
7401
9.28.10.26.14.26.15.14
7405
9.3.31.18.12.3.9.29.10
7407
9.31.23.19.5.10.16.4.30.24.5
7408
9.31.4.14.31.10.17.5.2
7410
9.5.9.3.23.9.25.14.1.29.28
7411
9.6.9.21.6.11.29.13.29.20.32
7417
SELECT * FROM ltreetest WHERE t @> '1.1.1' order by t asc;
7426
SELECT * FROM ltreetest WHERE t <@ '1.1.1' order by t asc;
7435
SELECT * FROM ltreetest WHERE t @ '23 & 1' order by t asc;
7437
--------------------------------
7440
1.12.25.26.22.8.15.23
7441
1.19.22.11.14.7.32.23.19.14
7443
1.26.15.23.5.31.29.11.19.28.1
7444
1.27.22.23.2.26.32.17.7.9
7445
10.12.9.6.6.26.14.8.23.1.25
7446
12.27.23.32.1.1.9.29.13
7447
14.1.15.25.27.23.25.26.28.10
7448
14.27.29.23.4.1.17.32.6.25.22
7449
15.11.26.1.30.6.23.5
7450
19.22.29.32.1.21.26.24.23.17
7452
21.23.17.8.23.11.8.1
7453
22.30.31.24.23.22.5.20.28.1
7455
23.12.1.5.32.25.8.24.1.25
7456
23.12.32.22.19.1.22.4
7457
23.17.22.1.23.4.29.32.4.1
7458
23.17.25.4.1.16.29.10
7459
23.19.17.31.29.13.1.12.5.25
7462
23.3.32.21.5.14.10.17.1
7463
27.29.1.5.30.6.22.16.23.2.28
7464
28.23.2.30.3.8.1.15.15.14.13
7466
29.23.15.25.1.6.6.10
7467
30.23.10.1.10.7.22.28.18.11.17
7468
31.30.23.7.7.24.32.10.11.1.31
7469
32.1.23.20.14.12.23.5.32.15
7470
32.15.20.28.5.1.23.4
7471
5.13.23.19.28.26.27.6.1.22
7473
7.23.1.24.29.13.31.19.23.17.7
7474
8.16.1.16.28.6.3.22.6.23
7476
9.5.9.3.23.9.25.14.1.29.28
7479
SELECT * FROM ltreetest WHERE t ~ '1.1.1.*' order by t asc;
7488
SELECT * FROM ltreetest WHERE t ~ '*.1' order by t asc;
7490
--------------------------------
7497
1.26.15.23.5.31.29.11.19.28.1
7498
10.13.22.1.8.30.9.24.1.2.1
7503
17.25.2.13.10.27.13.1
7504
18.13.6.12.26.26.26.29.18.20.1
7505
19.20.25.7.27.28.27.17.9.3.1
7510
21.23.17.8.23.11.8.1
7511
22.30.31.24.23.22.5.20.28.1
7512
23.17.22.1.23.4.29.32.4.1
7514
23.3.32.21.5.14.10.17.1
7520
6.27.29.14.8.12.26.3.21.4.1
7527
SELECT * FROM ltreetest WHERE t ~ '23.*{1}.1' order by t asc;
7533
SELECT * FROM ltreetest WHERE t ~ '23.*.1' order by t asc;
7535
---------------------------
7536
23.17.22.1.23.4.29.32.4.1
7538
23.3.32.21.5.14.10.17.1
7541
SELECT * FROM ltreetest WHERE t ~ '23.*.2' order by t asc;
7547
SELECT * FROM ltreetest WHERE t ? '{23.*.1,23.*.2}' order by t asc;
7549
---------------------------
7550
23.17.22.1.23.4.29.32.4.1
7553
23.3.32.21.5.14.10.17.1
7556
create table _ltreetest (t ltree[]);
7557
\copy _ltreetest FROM 'data/_ltree.data'
7558
SELECT count(*) FROM _ltreetest WHERE t @> '1.1.1' ;
7564
SELECT count(*) FROM _ltreetest WHERE t <@ '1.1.1' ;
7570
SELECT count(*) FROM _ltreetest WHERE t @ '23 & 1' ;
7576
SELECT count(*) FROM _ltreetest WHERE t ~ '1.1.1.*' ;
7582
SELECT count(*) FROM _ltreetest WHERE t ~ '*.1' ;
7588
SELECT count(*) FROM _ltreetest WHERE t ~ '23.*{1}.1' ;
7594
SELECT count(*) FROM _ltreetest WHERE t ~ '23.*.1' ;
7600
SELECT count(*) FROM _ltreetest WHERE t ~ '23.*.2' ;
7606
SELECT count(*) FROM _ltreetest WHERE t ? '{23.*.1,23.*.2}' ;
7612
create index _tstidx on _ltreetest using gist (t);
7613
set enable_seqscan=off;
7614
SELECT count(*) FROM _ltreetest WHERE t @> '1.1.1' ;
7620
SELECT count(*) FROM _ltreetest WHERE t <@ '1.1.1' ;
7626
SELECT count(*) FROM _ltreetest WHERE t @ '23 & 1' ;
7632
SELECT count(*) FROM _ltreetest WHERE t ~ '1.1.1.*' ;
7638
SELECT count(*) FROM _ltreetest WHERE t ~ '*.1' ;
7644
SELECT count(*) FROM _ltreetest WHERE t ~ '23.*{1}.1' ;
7650
SELECT count(*) FROM _ltreetest WHERE t ~ '23.*.1' ;
7656
SELECT count(*) FROM _ltreetest WHERE t ~ '23.*.2' ;
7662
SELECT count(*) FROM _ltreetest WHERE t ? '{23.*.1,23.*.2}' ;
added
removed
contrib/ltree/expected/ltree.out
