ltree.out

PostgreSQL7.4.6 for Linux

 f
(1 row)

SELECT 'a.b.c.d.e'::ltree ~ '*.!b.*';
 ?column? 
----------
 f
(1 row)

SELECT 'a.b.c.d.e'::ltree ~ '*.!b.c.*';
 ?column? 
----------
 f
(1 row)

SELECT 'a.b.c.d.e'::ltree ~ '*.!b.*.c.*';
 ?column? 
----------
 f
(1 row)

SELECT 'a.b.c.d.e'::ltree ~ '!b.*.c.*';
 ?column? 
----------
 t
(1 row)

SELECT 'a.b.c.d.e'::ltree ~ '!b.b.*';
 ?column? 
----------
 t
(1 row)

SELECT 'a.b.c.d.e'::ltree ~ '!b.*.e';
 ?column? 
----------
 t
(1 row)

SELECT 'a.b.c.d.e'::ltree ~ '!b.!c.*.e';
 ?column? 
----------
 t
(1 row)

SELECT 'a.b.c.d.e'::ltree ~ '!b.*.!c.*.e';
 ?column? 
----------
 t
(1 row)

SELECT 'a.b.c.d.e'::ltree ~ '*{2}.!b.*.!c.*.e';
 ?column? 
----------
 t
(1 row)

SELECT 'a.b.c.d.e'::ltree ~ '*{1}.!b.*.!c.*.e';
 ?column? 
----------
 f
(1 row)

SELECT 'a.b.c.d.e'::ltree ~ '*{1}.!b.*{1}.!c.*.e';
 ?column? 
----------
 t
(1 row)

SELECT 'a.b.c.d.e'::ltree ~ 'a.!b.*{1}.!c.*.e';
 ?column? 
----------
 t
(1 row)

SELECT 'a.b.c.d.e'::ltree ~ '!b.*{1}.!c.*.e';
 ?column? 
----------
 t
(1 row)

SELECT 'a.b.c.d.e'::ltree ~ '*.!b.*{1}.!c.*.e';
 ?column? 
----------
 t
(1 row)

SELECT 'a.b.c.d.e'::ltree ~ '*.!b.*.!c.*.e';
 ?column? 
----------
 f
(1 row)

SELECT 'a.b.c.d.e'::ltree ~ '!b.!c.*';
 ?column? 
----------
 t
(1 row)

SELECT 'a.b.c.d.e'::ltree ~ '!b.*.!c.*';
 ?column? 
----------
 t
(1 row)

SELECT 'a.b.c.d.e'::ltree ~ '*{2}.!b.*.!c.*';
 ?column? 
----------
 t
(1 row)

SELECT 'a.b.c.d.e'::ltree ~ '*{1}.!b.*.!c.*';
 ?column? 
----------
 f
(1 row)

SELECT 'a.b.c.d.e'::ltree ~ '*{1}.!b.*{1}.!c.*';
 ?column? 
----------
 t
(1 row)

SELECT 'a.b.c.d.e'::ltree ~ 'a.!b.*{1}.!c.*';
 ?column? 
----------
 t
(1 row)

SELECT 'a.b.c.d.e'::ltree ~ '!b.*{1}.!c.*';
 ?column? 
----------
 t
(1 row)

SELECT 'a.b.c.d.e'::ltree ~ '*.!b.*{1}.!c.*';
 ?column? 
----------
 t
(1 row)

SELECT 'a.b.c.d.e'::ltree ~ '*.!b.*.!c.*';
 ?column? 
----------
 f
(1 row)

SELECT 'QWER_TY'::ltree ~ 'q%@*';
 ?column? 
----------
 t
(1 row)

SELECT 'QWER_TY'::ltree ~ 'Q_t%@*';
 ?column? 
----------
 t
(1 row)

SELECT 'QWER_GY'::ltree ~ 'q_t%@*';
 ?column? 
----------
 f
(1 row)

--ltxtquery
SELECT '!tree & aWdf@*'::ltxtquery;
   ltxtquery    
----------------
 !tree & aWdf@*
(1 row)

SELECT 'tree & aw_qw%*'::ltxtquery;
   ltxtquery    
----------------
 tree & aw_qw%*
(1 row)

SELECT 'ltree.awdfg'::ltree @ '!tree & aWdf@*'::ltxtquery;
 ?column? 
----------
 t
(1 row)

SELECT 'tree.awdfg'::ltree @ '!tree & aWdf@*'::ltxtquery;
 ?column? 
----------
 f
(1 row)

SELECT 'tree.awdfg'::ltree @ '!tree | aWdf@*'::ltxtquery;
 ?column? 
----------
 t
(1 row)

SELECT 'tree.awdfg'::ltree @ 'tree | aWdf@*'::ltxtquery;
 ?column? 
----------
 t
(1 row)

SELECT 'tree.awdfg'::ltree @ 'tree & aWdf@*'::ltxtquery;
 ?column? 
----------
 t
(1 row)

SELECT 'tree.awdfg'::ltree @ 'tree & aWdf@'::ltxtquery;
 ?column? 
----------
 f
(1 row)

SELECT 'tree.awdfg'::ltree @ 'tree & aWdf*'::ltxtquery;
 ?column? 
----------
 f
(1 row)

SELECT 'tree.awdfg'::ltree @ 'tree & aWdf'::ltxtquery;
 ?column? 
----------
 f
(1 row)

SELECT 'tree.awdfg'::ltree @ 'tree & awdf*'::ltxtquery;
 ?column? 
----------
 t
(1 row)

SELECT 'tree.awdfg'::ltree @ 'tree & aWdfg@'::ltxtquery;
 ?column? 
----------
 t
(1 row)

SELECT 'tree.awdfg_qwerty'::ltree @ 'tree & aw_qw%*'::ltxtquery;
 ?column? 
----------
 t
(1 row)

SELECT 'tree.awdfg_qwerty'::ltree @ 'tree & aw_rw%*'::ltxtquery;
 ?column? 
----------
 f
(1 row)

--arrays
SELECT '{1.2.3}'::ltree[] @> '1.2.3.4';
 ?column? 
----------
 t
(1 row)

SELECT '{1.2.3.4}'::ltree[] @> '1.2.3.4';
 ?column? 
----------
 t
(1 row)

SELECT '{1.2.3.4.5}'::ltree[] @> '1.2.3.4';
 ?column? 
----------
 f
(1 row)

SELECT '{1.3.3}'::ltree[] @> '1.2.3.4';
 ?column? 
----------
 f
(1 row)

SELECT '{5.67.8, 1.2.3}'::ltree[] @> '1.2.3.4';
 ?column? 
----------
 t
(1 row)

SELECT '{5.67.8, 1.2.3.4}'::ltree[] @> '1.2.3.4';
 ?column? 
----------
 t
(1 row)

SELECT '{5.67.8, 1.2.3.4.5}'::ltree[] @> '1.2.3.4';
 ?column? 
----------
 f
(1 row)

SELECT '{5.67.8, 1.3.3}'::ltree[] @> '1.2.3.4';
 ?column? 
----------
 f
(1 row)

SELECT '{1.2.3, 7.12.asd}'::ltree[] @> '1.2.3.4';
 ?column? 
----------
 t
(1 row)

SELECT '{1.2.3.4, 7.12.asd}'::ltree[] @> '1.2.3.4';
 ?column? 
----------
 t
(1 row)

SELECT '{1.2.3.4.5, 7.12.asd}'::ltree[] @> '1.2.3.4';
 ?column? 
----------
 f
(1 row)

SELECT '{1.3.3, 7.12.asd}'::ltree[] @> '1.2.3.4';
 ?column? 
----------
 f
(1 row)

SELECT '{ltree.asd, tree.awdfg}'::ltree[] @ 'tree & aWdfg@'::ltxtquery;
 ?column? 
----------
 t
(1 row)

SELECT '{j.k.l.m, g.b.c.d.e}'::ltree[] ~ 'A*@|g.b.c.d.e';
 ?column? 
----------
 t
(1 row)

SELECT 'a.b.c.d.e'::ltree ? '{A.b.c.d.e}';
 ?column? 
----------
 f
(1 row)

SELECT 'a.b.c.d.e'::ltree ? '{a.b.c.d.e}';
 ?column? 
----------
 t
(1 row)

SELECT 'a.b.c.d.e'::ltree ? '{A.b.c.d.e, a.*}';
 ?column? 
----------
 t
(1 row)

SELECT '{a.b.c.d.e,B.df}'::ltree[] ? '{A.b.c.d.e}';
 ?column? 
----------
 f
(1 row)

SELECT '{a.b.c.d.e,B.df}'::ltree[] ? '{A.b.c.d.e,*.df}';
 ?column? 
----------
 t
(1 row)

--exractors
SELECT ('{3456,1.2.3.34}'::ltree[] ?@> '1.2.3.4') is null;
 ?column? 
----------
 t
(1 row)

SELECT '{3456,1.2.3}'::ltree[] ?@> '1.2.3.4';
 ?column? 
----------
 1.2.3
(1 row)

SELECT '{3456,1.2.3.4}'::ltree[] ?<@ '1.2.3';
 ?column? 
----------
 1.2.3.4
(1 row)

SELECT ('{3456,1.2.3.4}'::ltree[] ?<@ '1.2.5') is null;
 ?column? 
----------
 t
(1 row)

SELECT '{ltree.asd, tree.awdfg}'::ltree[] ?@ 'tree & aWdfg@'::ltxtquery;
  ?column?  
------------
 tree.awdfg
(1 row)

SELECT '{j.k.l.m, g.b.c.d.e}'::ltree[] ?~ 'A*@|g.b.c.d.e';
 ?column?  
-----------
 g.b.c.d.e
(1 row)

CREATE TABLE ltreetest (t ltree);
\copy ltreetest FROM 'data/ltree.data'
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