📄 ltree.out
字号:
4.18.29.9.16.10 4.19.16.15.5.2.25.8.28.14.2 4.2.16.13.16.11.19.10.10.25 4.2.2.32.24.25.31.3 4.2.6.20.7.8 4.21.28.5.16.29.5.21 4.21.9.1.2.14.8.17.13.26 4.22 4.22.17.10.19.9.8.19.28.3.9 4.22.7.19.25 4.25.12.10.15.9.18.9 4.26.2.2 4.26.23.6.19.31.10.4.22 4.26.5.26.21.28.17.24.25.23 4.27.32.18 4.3.20.27.9.1.18.30.12.5.19 4.3.6.27.22.23.10 4.30.8.20.19.9.30.24.11 4.31 4.5.9.4.15.19.8.26.17.26.3 4.7.1 4.9 5.1.5.31 5.10 5.10.2.11.21.9.19 5.10.3.9.23.30.23 5.12.2.20.1.24.25 5.13.23.19.28.26.27.6.1.22 5.13.23.4.9 5.14.27.15.11.17.3.10.27.25 5.14.29.2.23.16.20.22 5.15.10.3.23.13.32.23 5.15.16 5.18.9.25.31.21.22 5.19.1.26.20.6.20 5.2.32.19.13.29.12.13.31.29 5.20 5.21.27.13.14.11.2.16.20 5.23.31.18.24.32 5.24.24.9.32.26.31 5.24.25.15.27.30.20 5.24.4.31.3.16.25.17.13.26.11 5.27.16.3.30 5.27.21.1.29.29.28 5.27.28.26.14.15.6.20.1.31.13 5.27.32.21.5.1.11.14 5.3.17.29 5.3.29.9.22 5.31.8.1.5.13.21.28.29.19.2 5.4.8.25.12.27.2.29.28.3 5.5.12.31.23.13.17.22.20 5.8 5.8.17.30.15.8.19.29.30.11.6 5.9.19.6 6.1.8.6.30.29.30 6.10.25.12 6.11.11.5.16.8.14.12.9 6.11.31.23.12.8.30.14.27 6.13.31.5.7.26 6.14 6.17.10.10.7.9.27.8.29 6.17.26.25.27.11.10.9 6.18.1.4.18.23 6.19.29.11.2.32.21.15.32.9 6.19.3 6.19.6.4.9.11.32.17.17.3.15 6.2.32 6.20 6.20.14 6.21.30.7 6.22.12 6.25.17.32 6.26 6.26.29.10.21.28.20.19 6.27.26.1.20.24.6 6.27.29.14.8.12.26.3.21.4.1 6.29.32.13.30.3.16 6.29.6.13.14.24.10.4.14.28 6.5.27.19.13.26.1.18.9 6.6.22.8 6.7.25.16.13.21.7.20.25.12.4 6.7.7 6.8.7.20.2 6.9.1.10.10.22.6 6.9.29.17.4.32 7.10.17.21.11.29.17.25.19.4.29 7.11 7.12 7.12.1.10.6.17.29.24.24.4 7.12.23 7.13 7.13.15 7.14.22.29.30.14.25.1.9.26.25 7.16.20.17 7.19.10.12.31.1.27.13.19 7.19.12.3.21.19.18.5.2.14.10 7.19.6.17.15.26.21.9 7.21.8 7.23.1.24.29.13.31.19.23.17.7 7.23.15.32.28.27.2.2.26 7.26.18 7.27.20 7.30.19.25.23.15.14.29 7.30.5.10.10.5.30.14.9.18 7.31 7.31.2.28.15.11.17.18.19.23.6 7.31.4.20.17 7.32.10.3.30.12.14 7.5.28.8.17.26.31.10.15 7.7 7.7.22.24.17.32.17.25.28 7.7.25.22.22.26 8.1.29.18.22 8.10 8.11.20 8.12.4 8.13.1 8.13.14.11.11.29.22.4.4.10 8.13.6.12.18.7 8.13.9.31.20.20.24.7.23.31.28 8.14.19.18 8.16 8.16.1.16.28.6.3.22.6.23 8.16.20.24.20.6.10.21 8.16.30.29.19.22.28.24.2 8.16.6 8.17.25.26.15.25 8.17.9.15.21.28.1.7.1.3.6 8.2 8.2.18.23.5.16.17.1 8.21.17.3.6.3.18 8.21.8.23.4.18 8.22.32.17.16.28.31.23.22.9 8.24.11.13.25.19 8.25.20.3.15.24.7.4.24.5.30 8.26.29.13.7.25.31.28.3.32 8.27.3.4.12.26.16 8.29.6.3 8.3.18.13.30.20.27.26.17.28 8.3.3.25.25.15.7.13.21.18 8.31.22.27 8.32.30.1 8.5.24.9.29.32.31.30.13.9.7 8.5.30.29.9.31 8.6.6.5.8.8.12 8.9.21.16.29 8.9.22 8.9.25.25.26.30.31.31.2.32.7 9.10.19.18.15.11.22.32.32.14.9 9.10.32 9.14.27.31.26.21.25.3.20 9.16.2.16.22.24.17.31.14.21.17 9.17.13.31.7 9.18.23 9.18.30.11.29.32.7.19.2 9.19.7.13.13.25 9.2.10.4 9.2.4.27.26 9.21.14.19 9.21.20.29.1 9.21.28.8.12.15.3.13.10.11 9.22.10.15.5.15 9.23.21.22.5.29.15.21 9.26.1.16 9.28.10.26.14.26.15.14 9.28.24 9.28.30.1.6.25.17.9 9.3.3 9.3.31.18.12.3.9.29.10 9.30 9.31.23.19.5.10.16.4.30.24.5 9.31.4.14.31.10.17.5.2 9.5 9.5.9.3.23.9.25.14.1.29.28 9.6.9.21.6.11.29.13.29.20.32 9.7.31.11.8.23 9.8.23.2.20.16 9.9.13.9.14.27(882 rows)SELECT * FROM ltreetest WHERE t @> '1.1.1' order by t asc; t ------- 1 1.1 1.1.1(4 rows)SELECT * FROM ltreetest WHERE t <@ '1.1.1' order by t asc; t ----------- 1.1.1 1.1.1.1 1.1.1.2 1.1.1.2.1(4 rows)SELECT * FROM ltreetest WHERE t @ '23 & 1' order by t asc; t -------------------------------- 1.10.23.25.5.11 1.10.4.18.22.23.24 1.12.25.26.22.8.15.23 1.19.22.11.14.7.32.23.19.14 1.21.28.4.23 1.26.15.23.5.31.29.11.19.28.1 1.27.22.23.2.26.32.17.7.9 10.12.9.6.6.26.14.8.23.1.25 12.27.23.32.1.1.9.29.13 14.1.15.25.27.23.25.26.28.10 14.27.29.23.4.1.17.32.6.25.22 15.11.26.1.30.6.23.5 19.22.29.32.1.21.26.24.23.17 19.9.32.23.13.24.1 21.23.17.8.23.11.8.1 22.30.31.24.23.22.5.20.28.1 23.1.23.18.12.29 23.12.1.5.32.25.8.24.1.25 23.12.32.22.19.1.22.4 23.17.22.1.23.4.29.32.4.1 23.17.25.4.1.16.29.10 23.19.17.31.29.13.1.12.5.25 23.22.10.1.14.24 23.28.1 23.3.32.21.5.14.10.17.1 27.29.1.5.30.6.22.16.23.2.28 28.23.2.30.3.8.1.15.15.14.13 29.23.1.21.31.8 29.23.15.25.1.6.6.10 30.23.10.1.10.7.22.28.18.11.17 31.30.23.7.7.24.32.10.11.1.31 32.1.23.20.14.12.23.5.32.15 32.15.20.28.5.1.23.4 5.13.23.19.28.26.27.6.1.22 6.18.1.4.18.23 7.23.1.24.29.13.31.19.23.17.7 8.16.1.16.28.6.3.22.6.23 8.2.18.23.5.16.17.1 9.5.9.3.23.9.25.14.1.29.28(39 rows)SELECT * FROM ltreetest WHERE t ~ '1.1.1.*' order by t asc; t ----------- 1.1.1 1.1.1.1 1.1.1.2 1.1.1.2.1(4 rows)SELECT * FROM ltreetest WHERE t ~ '*.1' order by t asc; t -------------------------------- 1 1.1 1.1.1 1.1.1.1 1.1.1.2.1 1.1.2.1 1.26.15.23.5.31.29.11.19.28.1 10.13.22.1.8.30.9.24.1.2.1 10.22.1 10.26.30.15.1 11.1 12.1.1 17.25.2.13.10.27.13.1 18.13.6.12.26.26.26.29.18.20.1 19.20.25.7.27.28.27.17.9.3.1 19.9.32.23.13.24.1 20.17.18.21.1 20.4.27.31.1 21.18.2.1 21.23.17.8.23.11.8.1 22.30.31.24.23.22.5.20.28.1 23.17.22.1.23.4.29.32.4.1 23.28.1 23.3.32.21.5.14.10.17.1 25.6.12.16.1 29.1 29.15.29.8.31.26.1 32.31.11.22.1 4.7.1 6.27.29.14.8.12.26.3.21.4.1 8.13.1 8.2.18.23.5.16.17.1 8.32.30.1 9.21.20.29.1(34 rows)SELECT * FROM ltreetest WHERE t ~ '23.*{1}.1' order by t asc; t --------- 23.28.1(1 row)SELECT * FROM ltreetest WHERE t ~ '23.*.1' order by t asc; t --------------------------- 23.17.22.1.23.4.29.32.4.1 23.28.1 23.3.32.21.5.14.10.17.1(3 rows)SELECT * FROM ltreetest WHERE t ~ '23.*.2' order by t asc; t ------------------ 23.20.12.16.15.2(1 row)SELECT * FROM ltreetest WHERE t ? '{23.*.1,23.*.2}' order by t asc; t --------------------------- 23.17.22.1.23.4.29.32.4.1 23.20.12.16.15.2 23.28.1 23.3.32.21.5.14.10.17.1(4 rows)create unique index tstidx on ltreetest (t);set enable_seqscan=off;SELECT * FROM ltreetest WHERE t < '12.3' order by t asc; t ---------------------------------- 1 1.1 1.1.1 1.1.1.1 1.1.1.2 1.1.1.2.1 1.1.2 1.1.2.1 1.1.3 1.1.7.32.11.22 1.10.21 1.10.23.25.5.11 1.10.4.18.22.23.24 1.10.5.22.13 1.11.10.19.6.1.26.17.2.22 1.12.25.26.22.8.15.23 1.13.16.27.11.16.30.2.9.18.4 1.14.3.7.3.17.2.29 1.15.17.6.28.25.24.31.27.9 1.16.8.18.14.16.21.25.6 1.18.29.30.22.14.3.20.15.21.20 1.19.22.11.14.7.32.23.19.14 1.20.18.25.3.24.25.10.9 1.20.22.26.2.6.11 1.21.28.4.23 1.22.19.24.8.11 1.22.29.5.16 1.25.7.9.26.17.31.20.13 1.26 1.26.15.23.5.31.29.11.19.28.1 1.27.22.23.2.26.32.17.7.9 1.28.19.8.25.6.20.27.29.27 1.28.3.22 1.29.18.1.21.12.13.27.32.15 1.3.15.11.11.25.24.21.19 1.30.18.31.12.25.4.19.28.12.15 1.30.31.31.20.16.7 1.31.3 1.4.14.32.14 1.8 1.9.18.10.1.26.22.16.17 10.11.25.2.24.18.18.21.6.26.21 10.12.23.22.23.22.20.17.17.9 10.12.9.6.6.26.14.8.23.1.25 10.13.12.8.4.8.11.30 10.13.22.1.8.30.9.24.1.2.1 10.15.16.3 10.16.18.9.27.2.29.32.24.13 10.16.19.7.15 10.18.12.27.24.30.32.7.11.5.13 10.2.17.26.16.7.19.6.23.3 10.20 10.22.1 10.22.30.16.2.21.17.13 10.26.27.23.4.31.11.25.29 10.26.30.15.1 10.27.7.24.26.11.31.20.29 10.28.22.29.13.19.6.7.6.14 10.28.7.16.31 10.29 10.29.26.4.27.17.11 10.3 10.3.19 10.31 10.31.25.31.24.16.17 10.32.14 10.5.23.5.32.9.18.5.30 10.5.5.15.29.2 10.7.9 10.8.20.11.12.23.22 11.1 11.1.3.28.30.21.24.14 11.10 11.10.22.18 11.11.11.4.23.21.25 11.11.9.30.15.29.15.18 11.12.6.21 11.14.21.24.10.7.29.23.24.28 11.15.11.19.29.10 11.16.16.28.14 11.17.10 11.17.17.24.11.23.17.17.18.10.22 11.18.4.8.3.13.14.28.18.31 11.19.23.3.6.11 11.2.27.3 11.21.13.9.19 11.21.16.27.16 11.22.28.8.12.23.25.15.21.28 11.29 11.3.15.28.22.8.14 11.30 11.30.20.15.18.32.1.18.25.26.8 11.32.18.31 11.6.11.29.4.5.24.6.26.12 11.7.31.15.22 11.8.18 12.1.1 12.1.28.22.25 12.10 12.10.11.9.10.31.4.16.31 12.11.17.1.2 12.11.20.20.29 12.13.16.17.29.27.16.14.9.19.9 12.13.5.31 12.14.20.8.28.4 12.15.10.17.18.13 12.16.13 12.16.2.4.15 12.17.10.7.17.16 12.18 12.2.4.28.21.30.24 12.21.15.27.24.15.8.24.24.26 12.21.20.20 12.22.20.4.12 12.23.3.19.29.15.12.6 12.24.29.32.32.29.2 12.25.32.2.27.3.3.16 12.27.23.32.1.1.9.29.13 12.27.30.12.24.2.20 12.28.12.24.28.15.5.12.30.13.21 12.29.17.2.20.29.1.11.19.8.12 12.29.26.18.4.21.28.8.13.3(123 rows)SELECT * FROM ltreetest WHERE t <= '12.3' order by t asc; t ---------------------------------- 1 1.1 1.1.1 1.1.1.1 1.1.1.2 1.1.1.2.1 1.1.2 1.1.2.1 1.1.3 1.1.7.32.11.22 1.10.21 1.10.23.25.5.11 1.10.4.18.22.23.24 1.10.5.22.13 1.11.10.19.6.1.26.17.2.22 1.12.25.26.22.8.15.23 1.13.16.27.11.16.30.2.9.18.4 1.14.3.7.3.17.2.29 1.15.17.6.28.25.24.31.27.9 1.16.8.18.14.16.21.25.6 1.18.29.30.22.14.3.20.15.21.20 1.19.22.11.14.7.32.23.19.14 1.20.18.25.3.24.25.10.9 1.20.22.26.2.6.11 1.21.28.4.23 1.22.19.24.8.11 1.22.29.5.16 1.25.7.9.26.17.31.20.13 1.26 1.26.15.23.5.31.29.11.19.28.1 1.27.22.23.2.26.32.17.7.9 1.28.19.8.25.6.20.27.29.27 1.28.3.22 1.29.18.1.21.12.13.27.32.15 1.3.15.11.11.25.24.21.19 1.30.18.31.12.25.4.19.28.12.15 1.30.31.31.20.16.7 1.31.3 1.4.14.32.14 1.8 1.9.18.10.1.26.22.16.17 10.11.25.2.24.18.18.21.6.26.21 10.12.23.22.23.22.20.17.17.9 10.12.9.6.6.26.14.8.23.1.25 10.13.12.8.4.8.11.30 10.13.22.1.8.30.9.24.1.2.1 10.15.16.3 10.16.18.9.27.2.29.32.24.13 10.16.19.7.15 10.18.12.27.24.30.32.7.11.5.13 10.2.17.26.16.7.19.6.23.3 10.20 10.22.1 10.22.30.16.2.21.17.13 10.26.27.23.4.31.11.25.29 10.26.30.15.1 10.27.7.24.26.11.31.20.29 10.28.22.29.13.19.6.7.6.14 10.28.7.16.31 10.29 10.29.26.4.27.17.11 10.3 10.3.19 10.31 10.31.25.31.24.16.17 10.32.14 10.5.23.5.32.9.18.5.30 10.5.5.15.29.2 10.7.9 10.8.20.11.12.23.22 11.1 11.1.3.28.30.21.24.14 11.10 11.10.22.18 11.11.11.4.23.21.25 11.11.9.30.15.29.15.18 11.12.6.21 11.14.21.24.10.7.29.23.24.28 11.15.11.19.29.10 11.16.16.28.14 11.17.10 11.17.17.24.11.23.17.17.18.10.22 11.18.4.8.3.13.14.28.18.31 11.19.23.3.6.11 11.2.27.3 11.21.13.9.19 11.21.16.27.16 11.22.28.8.12.23.25.15.21.28 11.29 11.3.15.28.22.8.14 11.30 11.30.20.15.18.32.1.18.25.26.8 11.32.18.31 11.6.11.29.4.5.24.6.26.12 11.7.31.15.22 11.8.18 12.1.1 12.1.28.22.25 12.10 12.10.11.9.10.31.4.16.31 12.11.17.1.2 12.11.20.20.29 12.13.16.17.29.27.16.14.9.19.9 12.13.5.31 12.14.20.8.28.4 12.15.10.17.18.13 12.16.13 12.16.2.4.15 12.17.10.7.17.16 12.18 12.2.4.28.21.30.24 12.21.15.27.24.15.8.24.24.26 12.21.20.20 12.22.20.4.12 12.23.3.19.29.15.12.6 12.24.29.32.32.29.2 12.25.32.2.27.3.3.16 12.27.23.32.1.1.9.29.13 12.27.30.12.24.2.20 12.28.12.24.28.15.5.12.30.13.21 12.29.17.2.20.29.1.11.19.8.12 12.29.26.18.4.21.28.8.13.3 12.3(124 rows)SELECT * FROM ltreetest WHERE t = '12.3' order by t asc; t ------ 12.3(1 row)SELECT * FROM ltreetest WHERE t >= '12.3' order by t asc; t ---------------------------------- 12.3 12.4.10.17.4.10.23.3 12.4.12.13.25.30.30.8.9.12 12.4.24.6.1.13.5.20 12.4.26.23.25.5.15.7.16 12.6.14.23.19.21.9.12 12.7.16.8.21.22.2.16.18 12.7.28.26.14.21.18.31.5.15.11 13.1.6.17.28.9.15.30.1.27.14 13.12 13.14.13.10.28.26.9.18.27.21 13.16.1.27.18.18.19.6.14.4 13.16.4.28 13.17.7 13.19.2.6.23.19.9.7.21.8.16 13.24 13.25.10.25.8.16 13.26.17.3.2.19 13.28.12.6 13.28.14.2.8.18 13.28.9.3 13.3.20 13.3.8 13.30.24 13.32.15.32.26.14.32 13.7 13.8.15.3.7.31.5.10.15.30 13.8.20.9.21 13.8.23.13.11.18.24.21.11.24.10 13.9.9.27.31.11.25.9.27.22.13 14.1.11 14.1.15.25.27.23.25.26.28.10 14.10.11.30.5.7.6.24.9.30.26 14.11.25 14.12.31 14.13.9.13.11.5.5.2.2.32.12 14.14.25 14.15.31.29 14.16.6.29.26.13.14.16.25.26.8 14.17.7.30.8.25.26.4 14.19.20.13.27.2.2 14.19.26.15.22.23 14.19.30.6.4.10.10.10.22.25.11 14.2.14.11.12 14.21.22 14.21.5.28.3.32.24.14.25.31 14.21.6.5.26.9.32.16.25 14.23.31.5.5.15.17.12.17.7.3 14.24 14.26.25.4.12.26.8 14.27.29.23.4.1.17.32.6.25.22 14.29 14.3.17.1.14.15.21.4.26 14.30.13.5.26.9.22.23.14.10 14.30.2.21.15.16.13 14.30.23.3 14.4.19.27.28.24.19 14.4.23.4.23.22.11.6.26.5 14.5.13.19.25.12.32.9.13.16.12 14.6.10.29.25.26.20.24.24 14.8.15.30.7.29.27.31.4 14.9.15.21.21.31.1.29 15.1.6.31.30.13.32.9.10 15.1.8 15.10.30.1.4.12.8.20 15.11.26.1.30.6.23.5 15.17 15.17.2.32.7 15.21.22 15.21.23.30.9.25 15.23.26.20.27.7 15.25.31.11.4.22.16.7.11 15.26.24.31.16.15.17.22.8.30.3 15.28.24 15.28.30.19.31.6.2.2.31 15.29.25 15.29.32.16.29.12.20.32.13.20 15.3.31.9.27.14.9.8.14.6.32 15.30.17.5.32.28.2.18.27 15.31.11.27.19.19.20.5.5 15.4.15 15.5.1.31.28.10.8 15.6.19.3 15.7.3.14.23.19.26 15.7.5.12.7.9.3.28.26 15.8.10 15.8.3.15.27.14.29.28.6.5.25 15.9.11.20.22.15.11.13 15.9.8.20.27 16.13.19.11.18.13.17.17 16.13.2.19.14.29.31.30.23.15.12 16.13.26.18.9.29.11.17.1.24.26 16.14.3.17.17.26.12.19.19.30 16.16.28.24.11 16.18.23.6.31 16.19.17.30.30.5.17.24.27 16.2.14.3.26.11 16.20.29.26 16.21.13.1.4 16.23.30.12.31.31.19.14 16.24.3.30.15.22.31.2 16.24.7.25 16.27.8.17.14.17.21.29.14 16.28 16.29.6.23.13.28.31.6.19.26.15 16.30.10.7.29.4.9.21.22.13.26 16.31.12.27.25.9.32.29 16.5 16.5.10.2.18.8.15.12.32.25.10 16.5.12.5.15.12.24.25.3 16.5.14.21.32.17.23.3.4.26 16.5.23.17 16.5.6.12 16.8.29.7.21.2.3 16.9.14.28.6.21.31.31.26 16.9.29 16.9.32.14.3.7.8.7.21.22 17.1.12.20 17.10.17.22.20.25.14.13 17.11.17.4.8.26.26.20.6 17.13.14.29.27.27.13.12.15 17.13.19.31.12.18.10.15.14 17.13.8 17.14.7.3.2.18.20.23.18.5 17.17.14.28.6.30 17.19.1.22.11.7.22.1.14.28.11 17.22.12.10.30.11 17.24.15.27.3.32.4.22.20.6.24 17.24.30.6.32 17.25.10.13.21.5.7.22.2 17.25.2.13.10.27.13.1 17.25.26.23.32 17.26.18 17.27 17.29.21.10.18.8.16.26.18.21.26 17.29.31.8.24.10.18.27.17 17.3 17.5.3.15.17.13.5 17.7.26.30.18.23.4 17.8 17.8.31.32 17.9.32.31.21.31.23.17.10.32.9 18.13.6.12.26.26.26.29.18.20.1 18.13.9.3.18.15.2 18.15.14 18.17.6.16.6.10 18.18.19.16.14.16.21.10.25 18.18.5.11.7.4.25 18.19.11.20.13.13.11 18.19.12.20.18.17.15.32.18.5 18.21 18.24.21.17.11.26.28.22.21.18.10 18.27.11.27.9.16.7.6.22.26.27 18.29.13.24.18.3.12.18.12.12 18.29.5.1.10.21.2 18.30.11.17 18.30.18.31 18.31.26.18.6.15.18.11 18.31.32.28.1.4.24.24.12.25 18.31.32.29.22.1.31.11.28 18.4 18.4.14.29.3 18.5.6.31.5.15.15 18.6.2.2.24 18.6.26.2.13.9.6.11.10.11.16 18.7.10.27.17.24
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -