ltree.out

PostgreSQL7.4.6 for Linux

\set ECHO none
psql:ltree.sql:7: NOTICE:  type "ltree" is not yet defined
DETAIL:  Creating a shell type definition.
psql:ltree.sql:12: NOTICE:  argument type ltree is only a shell
psql:ltree.sql:299: NOTICE:  type "lquery" is not yet defined
DETAIL:  Creating a shell type definition.
psql:ltree.sql:304: NOTICE:  argument type lquery is only a shell
psql:ltree.sql:410: NOTICE:  type "ltxtquery" is not yet defined
DETAIL:  Creating a shell type definition.
psql:ltree.sql:415: NOTICE:  argument type ltxtquery is only a shell
psql:ltree.sql:477: NOTICE:  type "ltree_gist" is not yet defined
DETAIL:  Creating a shell type definition.
psql:ltree.sql:482: NOTICE:  argument type ltree_gist is only a shell
SELECT ''::ltree;
 ltree 
-------
 
(1 row)

SELECT '1'::ltree;
 ltree 
-------
 1
(1 row)

SELECT '1.2'::ltree;
 ltree 
-------
 1.2
(1 row)

SELECT '1.2._3'::ltree;
 ltree  
--------
 1.2._3
(1 row)

SELECT ltree2text('1.2.3.34.sdf');
  ltree2text  
--------------
 1.2.3.34.sdf
(1 row)

SELECT text2ltree('1.2.3.34.sdf');
  text2ltree  
--------------
 1.2.3.34.sdf
(1 row)

SELECT subltree('Top.Child1.Child2',1,2);
 subltree 
----------
 Child1
(1 row)

SELECT subpath('Top.Child1.Child2',1,2);
    subpath    
---------------
 Child1.Child2
(1 row)

SELECT subpath('Top.Child1.Child2',-1,1);
 subpath 
---------
 Child2
(1 row)

SELECT subpath('Top.Child1.Child2',0,-2);
 subpath 
---------
 Top
(1 row)

SELECT subpath('Top.Child1.Child2',0,-1);
  subpath   
------------
 Top.Child1
(1 row)

SELECT subpath('Top.Child1.Child2',0,0);
 subpath 
---------
 
(1 row)

SELECT subpath('Top.Child1.Child2',1,0);
 subpath 
---------
 
(1 row)

SELECT subpath('Top.Child1.Child2',0);
      subpath      
-------------------
 Top.Child1.Child2
(1 row)

SELECT subpath('Top.Child1.Child2',1);
    subpath    
---------------
 Child1.Child2
(1 row)

SELECT index('1.2.3.4.5.6','1.2');
 index 
-------
     0
(1 row)

SELECT index('a.1.2.3.4.5.6','1.2');
 index 
-------
     1
(1 row)

SELECT index('a.1.2.3.4.5.6','1.2.3');
 index 
-------
     1
(1 row)

SELECT index('a.1.2.3.4.5.6','1.2.3.j');
 index 
-------
    -1
(1 row)

SELECT index('a.1.2.3.4.5.6','1.2.3.j.4.5.5.5.5.5.5');
 index 
-------
    -1
(1 row)

SELECT index('a.1.2.3.4.5.6','1.2.3');
 index 
-------
     1
(1 row)

SELECT index('a.1.2.3.4.5.6','6');
 index 
-------
     6
(1 row)

SELECT index('a.1.2.3.4.5.6','6.1');
 index 
-------
    -1
(1 row)

SELECT index('a.1.2.3.4.5.6','5.6');
 index 
-------
     5
(1 row)

SELECT index('0.1.2.3.5.4.5.6','5.6');
 index 
-------
     6
(1 row)

SELECT index('0.1.2.3.5.4.5.6.8.5.6.8','5.6',3);
 index 
-------
     6
(1 row)

SELECT index('0.1.2.3.5.4.5.6.8.5.6.8','5.6',6);
 index 
-------
     6
(1 row)

SELECT index('0.1.2.3.5.4.5.6.8.5.6.8','5.6',7);
 index 
-------
     9
(1 row)

SELECT index('0.1.2.3.5.4.5.6.8.5.6.8','5.6',-7);
 index 
-------
     6
(1 row)

SELECT index('0.1.2.3.5.4.5.6.8.5.6.8','5.6',-4);
 index 
-------
     9
(1 row)

SELECT index('0.1.2.3.5.4.5.6.8.5.6.8','5.6',-3);
 index 
-------
     9
(1 row)

SELECT index('0.1.2.3.5.4.5.6.8.5.6.8','5.6',-2);
 index 
-------
    -1
(1 row)

SELECT index('0.1.2.3.5.4.5.6.8.5.6.8','5.6',-20000);
 index 
-------
     6
(1 row)

SELECT 'Top.Child1.Child2'::ltree || 'Child3'::text;
         ?column?         
--------------------------
 Top.Child1.Child2.Child3
(1 row)

SELECT 'Top.Child1.Child2'::ltree || 'Child3'::ltree;
         ?column?         
--------------------------
 Top.Child1.Child2.Child3
(1 row)

SELECT 'Top_0'::ltree || 'Top.Child1.Child2'::ltree;
        ?column?         
-------------------------
 Top_0.Top.Child1.Child2
(1 row)

SELECT 'Top.Child1.Child2'::ltree || ''::ltree;
     ?column?      
-------------------
 Top.Child1.Child2
(1 row)

SELECT ''::ltree || 'Top.Child1.Child2'::ltree;
     ?column?      
-------------------
 Top.Child1.Child2
(1 row)

SELECT lca('{la.2.3,1.2.3.4.5.6,}') IS NULL;
 ?column? 
----------
 t
(1 row)

SELECT lca('{la.2.3,1.2.3.4.5.6}') IS NULL;
 ?column? 
----------
 f
(1 row)

SELECT lca('{1.la.2.3,1.2.3.4.5.6}');
 lca 
-----
 1
(1 row)

SELECT lca('{1.2.3,1.2.3.4.5.6}');
 lca 
-----
 1.2
(1 row)

SELECT lca('1.la.2.3','1.2.3.4.5.6');
 lca 
-----
 1
(1 row)

SELECT lca('1.2.3','1.2.3.4.5.6');
 lca 
-----
 1.2
(1 row)

SELECT lca('1.2.2.3','1.2.3.4.5.6');
 lca 
-----
 1.2
(1 row)

SELECT lca('1.2.2.3','1.2.3.4.5.6','');
 lca 
-----
 
(1 row)

SELECT lca('1.2.2.3','1.2.3.4.5.6','2');
 lca 
-----
 
(1 row)

SELECT lca('1.2.2.3','1.2.3.4.5.6','1');
 lca 
-----
 
(1 row)

SELECT '1'::lquery;
 lquery 
--------
 1
(1 row)

SELECT '4|3|2'::lquery;
 lquery 
--------
 4|3|2
(1 row)

SELECT '1.2'::lquery;
 lquery 
--------
 1.2
(1 row)

SELECT '1.4|3|2'::lquery;
 lquery  
---------
 1.4|3|2
(1 row)

SELECT '1.0'::lquery;
 lquery 
--------
 1.0
(1 row)

SELECT '4|3|2.0'::lquery;
 lquery  
---------
 4|3|2.0
(1 row)

SELECT '1.2.0'::lquery;
 lquery 
--------
 1.2.0
(1 row)

SELECT '1.4|3|2.0'::lquery;
  lquery   
-----------
 1.4|3|2.0
(1 row)

SELECT '1.*'::lquery;
 lquery 
--------
 1.*
(1 row)

SELECT '4|3|2.*'::lquery;
 lquery  
---------
 4|3|2.*
(1 row)

SELECT '1.2.*'::lquery;
 lquery 
--------
 1.2.*
(1 row)

SELECT '1.4|3|2.*'::lquery;
  lquery   
-----------
 1.4|3|2.*
(1 row)

SELECT '*.1.*'::lquery;
 lquery 
--------
 *.1.*
(1 row)

SELECT '*.4|3|2.*'::lquery;
  lquery   
-----------
 *.4|3|2.*
(1 row)

SELECT '*.1.2.*'::lquery;
 lquery  
---------
 *.1.2.*
(1 row)

SELECT '*.1.4|3|2.*'::lquery;
   lquery    
-------------
 *.1.4|3|2.*
(1 row)

SELECT '1.*.4|3|2'::lquery;
  lquery   
-----------
 1.*.4|3|2
(1 row)

SELECT '1.*.4|3|2.0'::lquery;
   lquery    
-------------
 1.*.4|3|2.0
(1 row)

SELECT '1.*.4|3|2.*{1,4}'::lquery;
      lquery      
------------------
 1.*.4|3|2.*{1,4}
(1 row)

SELECT '1.*.4|3|2.*{,4}'::lquery;
     lquery      
-----------------
 1.*.4|3|2.*{,4}
(1 row)

SELECT '1.*.4|3|2.*{1,}'::lquery;
     lquery      
-----------------
 1.*.4|3|2.*{1,}
(1 row)

SELECT '1.*.4|3|2.*{1}'::lquery;
     lquery     
----------------
 1.*.4|3|2.*{1}
(1 row)

SELECT 'qwerty%@*.tu'::lquery;
    lquery    
--------------
 qwerty%@*.tu
(1 row)

SELECT nlevel('1.2.3.4');
 nlevel 
--------
      4
(1 row)

SELECT '1.2'::ltree  < '2.2'::ltree;
 ?column? 
----------
 t
(1 row)

SELECT '1.2'::ltree  <= '2.2'::ltree;
 ?column? 
----------
 t
(1 row)

SELECT '2.2'::ltree  = '2.2'::ltree;
 ?column? 
----------
 t
(1 row)

SELECT '3.2'::ltree  >= '2.2'::ltree;
 ?column? 
----------
 t
(1 row)

SELECT '3.2'::ltree  > '2.2'::ltree;
 ?column? 
----------
 t
(1 row)

SELECT '1.2.3'::ltree @> '1.2.3.4'::ltree;
 ?column? 
----------
 t
(1 row)

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

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

SELECT '1.3.3'::ltree @> '1.2.3.4'::ltree;
 ?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';
 ?column? 
----------
 f
(1 row)

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

SELECT 'aa.b.c.d.e'::ltree ~ 'A@.b.c.d.e';
 ?column? 
----------
 f
(1 row)

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

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

SELECT 'aa.b.c.d.e'::ltree ~ 'A*@|g.b.c.d.e';
 ?column? 
----------
 t
(1 row)

SELECT '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? 
----------
 t
(1 row)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT 'a.b.c.d.e'::ltree ~ '*.a.*.!d.*';
 ?column? 
----------