Move ltree parentsel() selectivity function into /contrib/ltree.

[postgresql] / contrib / ltree / expected / ltree.out

\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:304: NOTICE:  type "lquery" is not yet defined
DETAIL:  Creating a shell type definition.
psql:ltree.sql:309: NOTICE:  argument type lquery is only a shell
psql:ltree.sql:415: NOTICE:  type "ltxtquery" is not yet defined
DETAIL:  Creating a shell type definition.
psql:ltree.sql:420: NOTICE:  argument type ltxtquery is only a shell
psql:ltree.sql:482: NOTICE:  type "ltree_gist" is not yet defined
DETAIL:  Creating a shell type definition.
psql:ltree.sql:487: 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? 
----------
 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
 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
 18.7.3.17.13.5.31.6.31.25.29
 18.9.21.2.31.8.32
 18.9.26.7
 19.10.26.19.5.21.30.23
 19.10.4.30.32.4.12
 19.10.8.10.4.19
 19.11.10.18.14.13.7.7
 19.11.29.13.15.27.12.15.14.12
 19.12.20.24.32.13.11.23.26
 19.12.26.24.29.3
 19.12.30.2.21
 19.15.26.19
 19.16.26.2
 19.16.31.31.29.12
 19.17.12.15
 19.17.13.12.32.16.3
 19.19.25.22.11.6.15.3.2.19
 19.2.26.21.16.11.2.2
 19.2.9.29.6
 19.20.25.7.27.28.27.17.9.3.1
 19.22.21.13.27.13.15
 19.22.29.32.1.21.26.24.23.17
 19.26.24.27.6.24.16.27.32.29
 19.26.32.13.1.12.30.26.22.25
 19.3.12.12
 19.3.23.4.4.21.23
 19.30.18.11.32.14
 19.30.27.26.21.7.18
 19.31.14.25.5.8.21.11.13.20
 19.5.20.3.4.2.3
 19.6.13.14.22.13.9.29
 19.6.24.32.30.13.6.25.8.28
 19.7
 19.7.29.31.3.20.7.21.25.27.29
 19.9.32.23.13.24.1
 2.1.12.19.29.28.3.31.28.28.10
 2.1.3.30.24.17.9
 2.10.10.4.20.1.12.13
 2.10.28.1.17.19.32.28
 2.11.32.25.23
 2.12.14.28.16.21
 2.12.30.22.12
 2.13.9.23.21.2
 2.13.9.28
 2.14.10.4.17.17.8.4.27.20
 2.14.12.13
 2.15.14.20.30.26
 2.15.18.21.5.21.4.7.30
 2.16.3.7.22.18.29.20
 2.19.4.1.15.7.8.9.17.29
 2.2.18.18.3.3.18.8.10.8
 2.22.19
 2.24.4.5.24.32
 2.24.5.3.4.10.27.26.17.28.16
 2.27.15.14
 2.28.5.17.6.32
 2.30.26.10.14.31.18.2
 2.31.25
 2.32.10.13.12
 2.32.8.28.24.20.9.24.25.8.9
 2.4.25.32.16.22.26.13.17.18
 2.6.15.26.23.26.24
 2.8.13.12.17.23.16.7.11.23
 2.9
 20.1.24.3.30.31
 20.13
 20.14.11.2.10.14
 20.15
 20.17.14.7
 20.17.18.21.1
 20.18.24.14.12.13.9
 20.20.32.29.24.5.5.26.22.32
 20.20.7
 20.22.10
 20.23.29.5.7.30.13.14.22
 20.23.7.11.11.31.18.16.3
 20.24.14.15.4.21.12.27.4.12
 20.25.22.19.22
 20.28.22.7.10.28.27.22.14.16
 20.29.18.16.2.21.23.11
 20.3.1.8.8.30.20
 20.30.17
 20.30.28.15.17
 20.30.9.9.14.12.29
 20.31.13.12.19.2.26.16.16.22.28
 20.32.5.1.3.20.3.30.27
 20.32.9
 20.4.1.16.31.3
 20.4.27.31.1
 20.5.4.9.31.14.26.6
 20.6.26.3.30
 20.6.3.26.7.29.28.4
 20.8.19.14.16.7
 20.9.29.32.13.7.23
 21.1.4.9.9.31.24.21.3.29
 21.10.20.9.3.16.9.10.20
 21.14
 21.14.13
 21.14.22.29
 21.14.25.20.13.31.14.20
 21.15.18.18.30.3.20
 21.15.31.24.29.24.26.12.20
 21.17.18.32.7.8
 21.17.27.23.15
 21.17.31.10.31.13.9.26.6.14
 21.18
 21.18.2.1
 21.18.30.19.24.24
 21.20.24.25.6.26.23
 21.20.28.19.27.9
 21.21.10.27
 21.22.31.24.27
 21.23.13
 21.23.17.8.23.11.8.1
 21.28.17.22.10.27.4.20.2.32
 21.28.24.23.3.11.7.12.22.32
 21.30.19.6.28.1.32.2.14.14
 21.31.31.25.5.30.26
 21.32.13.21
 21.32.13.22.3.13.31.23.14.12.9
 21.4.11.18
 21.4.22.20.24.28.6
 21.5.11.18
 21.5.17.19.15.25.18.21.24.9
 21.6.22.28.12.23.11.22
 21.7.23.9.16.5.18.14
 21.7.7.11
 21.8.9
 21.9.27.22.32
 21.9.32.1.27
 22.10.12.23.9
 22.10.16.8
 22.10.18
 22.10.27.19.29.20.29.3.12.14.25
 22.11
 22.12.22.28
 22.13.22.21.25.17.8
 22.13.22.8.30.32.10.24
 22.15
 22.16
 22.16.25.18.25.7.24.29.14.8
 22.17.24.14.21.15.12.18.17.25.11
 22.17.30
 22.17.4.2.22.17
 22.17.7.30.13.24
 22.17.9.11.25.15.3.9
 22.18.20.23.15.9.12
 22.19.20.5.2.20
 22.19.21.11.6.8.29.24
 22.19.5.22.20.31.23.24.14.24.4
 22.20.30
 22.21.32.15.8.29.5.12.10.29
 22.22.10.30.5.15.25.21.19.11
 22.22.27.6.27.15.5.18.21.28.9
 22.23.18.18.9.8.23.7.23.23.16
 22.23.22.30
 22.23.25.28.5.27.9.9.24.31.10
 22.24.22.25.15.23.13
 22.25.4.28.9.20.12.13
 22.26.1.28.9.9.31
 22.26.32
 22.28.20.6.32.32
 22.29.18.32.13.12.22.31.17.22
 22.29.29.11
 22.3.6
 22.30
 22.30.31.24.23.22.5.20.28.1
 22.31.2.32.32.11.26.23.19
 22.31.21.13.13.26.11.5.19
 22.32.6.6.3.8.24.6.25.29
 22.8.20.1.10.28.6.27
 22.9.15.19.12
 23.1.23.18.12.29
 23.10.13.32.14.20.16.11.14
 23.10.5.26.12.4.20.4
 23.12.1.5.32.25.8.24.1.25
 23.12.11.11.15.16.22.31.32.5.8
 23.12.19.25.16.23.22.6.29.4
 23.12.32.22.19.1.22.4
 23.14.12.30.18.4.16.18.7.7
 23.14.30.27.28.26.26.23.8.32
 23.17.22.1.23.4.29.32.4.1
 23.17.25.4.1.16.29.10
 23.17.28.31.28
 23.17.32.15.23.16.25
 23.19.17.31.29.13.1.12.5.25
 23.2.22.7.32.3.27.6
 23.20.12.16.15.2
 23.20.24
 23.20.8
 23.22.10.1.14.24
 23.22.23.14.31.32
 23.23
 23.24.11.31.10.31.18.28.13.18.6
 23.24.16.32.13.29
 23.25.23.11.7.23
 23.27.27.16
 23.27.6.26.22
 23.28.1
 23.28.20.25.30.24.15
 23.28.3.30.15.31.32.3.21.9.19
 23.3.20.24
 23.3.32.21.5.14.10.17.1
 23.31.27.16.8.30.20.27
 23.32.5.25.19.9.15.17.15.11
 23.5.5.17
 23.5.7.12.11.23.10
 23.6.27
 23.8.13.22.21
 24.1.10.20.28.18.6.27.20.30.26
 24.1.29.32.14.15.32.6.15.22
 24.10.10.31.4.29.9
 24.10.8.25.16
 24.11.5
 24.12
 24.13.1.8
 24.15.15.17.22
 24.16.27.10.9
 24.17.24
 24.17.31.20.12.9.19.29.18
 24.18.16
 24.2.26.24.14.15.31.23.17.26
 24.2.6.7.16.7.28
 24.20.23
 24.21.14.25.11.3.20.6.6.16
 24.23.24.4.15.25.17
 24.23.29.8.24.11.21.10.28.14.27
 24.24
 24.25.7.27.30.8.26.17
 24.27.14
 24.27.18.32.14.9.11.28.9
 24.28.13.26.8.8.31
 24.28.32.21
 24.3.23.25
 24.31
 24.31.2.13.5.23.18.16
 24.31.8
 24.32.17.23.24.19.23.9.20.18
 24.32.27
 24.9
 24.9.15.1.14.29.6.4
 24.9.27.16.20.21
 24.9.8.12.29
 25.10
 25.10.29.3.6.21.3.31.13
 25.10.4.28.3.31.19
 25.11.24
 25.14.5.32.25
 25.15.11
 25.16.9.6
 25.17.18.17.27
 25.17.18.30
 25.17.2.20.20.3.29.21.3.12
 25.17.9.16.17.31.23.29.24
 25.18.8.3.23.23.5.9.6
 25.19.27.2.9.20
 25.2.11.20.8.6.22
 25.2.3.15.11.19.5.28.25.14
 25.21.8.17
 25.22.2.25.6
 25.24.2.32.14.18.16
 25.24.29
 25.28.3
 25.28.30.24
 25.29
 25.3
 25.30.1.4.24.11
 25.31
 25.32.24.24.28.15.16.10
 25.4.32
 25.4.4.1.13.32.26.20.20.3
 25.5.30.7.16.12.21.12.11.16
 25.6
 25.6.12.16.1
 25.7.3.21.31.12.28
 25.9
 25.9.1.5.9.11.25.4.11.27.32
 25.9.10
 26.11
 26.12.27.2
 26.13.4.7.13.11.3
 26.14
 26.14.5.32.10
 26.16.12
 26.16.12.3.27.9.28
 26.17.9.13.4.25.32.2.24.9
 26.18
 26.18.32.20
 26.19.3.14.8.28.31.10
 26.24
 26.24.9.12.11.15.31.2
 26.25.10.10.13
 26.25.24
 26.26.22.21.14.11.29.19.14.24
 26.28.14
 26.31.11.23.3
 26.31.16.18.22.13.32.23.9.20
 26.31.6.8.29.8.24
 26.31.7
 26.32.21.31.27.12
 26.32.8.12.30.19.24.8.6.1.10
 26.5.29.7.28
 26.7.22.3.18.21.11
 26.7.5.8.11.9.22.1.6
 26.8.28
 26.9.17.1.18.19.1.11.18.29.3
 26.9.20.12.22.22.32
 27.1.11.3.25.9.6.6
 27.11.14.17.24
 27.11.15.9.24.31.18.4.1.30.20
 27.12.4.2.29.22.15
 27.15.15.15
 27.16
 27.17.15.7.28.20
 27.17.17.19.24.9.14.20
 27.17.3.18.2.13.18
 27.18
 27.18.10.4.22
 27.19.20.1.31.29.5.22.26.3
 27.2.10.4.25.14.2.15.4
 27.21.27.5.13.30.17
 27.21.28.24.7.2.24.23.8
 27.22.11.13.21.25.5.1.27.21.27
 27.23.2.32.11.21
 27.23.20.30.7
 27.24.11.31.21.6.29.17.24.18
 27.25
 27.26.29
 27.27
 27.27.25.10.31.10.21.22.21.16.12
 27.27.30.11.15.24.9.7.4.30
 27.29.1.5.30.6.22.16.23.2.28
 27.3
 27.3.3.11.21.4.25
 27.30.12.11.20.15.11.13
 27.31.2.16.29.6
 27.32.26.21.31.17.32.32
 27.4
 27.4.15.14.19.6.12
 27.4.17.17.32.8.16.15.17.13
 27.5.15.1.15.16.21
 27.5.22
 27.6.13.24.21.27.28.22.3.7.4
 28.1.3
 28.11.11.30.20.11.32
 28.11.27.21.14.16
 28.14.24.26.6.15.16.32.25.13.8
 28.14.32.29.2.3.4
 28.15.18.27
 28.15.25.7.13.6.19.2
 28.17.26.9
 28.18.6.22.13.8.25
 28.2.27.1.20
 28.20.8.9.9.28.30.29
 28.23.2.30.3.8.1.15.15.14.13
 28.25.10.25.19.15
 28.25.11.22
 28.25.29.4.13.5.6
 28.26.25.7
 28.26.26.6.31
 28.26.4.22.13.20.32.27.15
 28.27.24.14
 28.28
 28.30.24.16.17.28.2.13.10
 28.31.10.28.22.26.16.15
 28.4
 28.5.12.9.2.27.11.11.2
 28.5.13
 28.6
 28.6.11.6.15.22.12.6
 28.6.8.22.25
 28.8.21.15.16.28.4.16.26.8
 28.9.3.16.17.21.23.30
 29.1
 29.1.2.14.14
 29.1.7.26.25.11.22
 29.10.12.17.12.16
 29.10.17.11.28.12.18.5.19.15.21
 29.11.20.22.27
 29.14.12.9.17.5.32
 29.14.31.25.7.32.23
 29.15.29.8.31.26.1
 29.20.1.11.21.16.1.2.14.28
 29.23.1.21.31.8
 29.23.15.25.1.6.6.10
 29.25.29.16.32.11.15.25.5.22.3
 29.25.30.15.21.3.25.26.26
 29.26.25.14.24.18.2.13.23.29
 29.27
 29.27.13.29.10.2
 29.27.13.9.28.29.19.13.29.31.27
 29.27.5.22.26
 29.27.7.7.3.11.14.26.21.11
 29.28.9.15.8.27.31
 29.29.17.31
 29.29.18
 29.3.15.17.12.29
 29.3.17.17.18.32
 29.30.21.8.16.23.32
 29.30.7.31.22
 29.32.13.4.1.16.20
 29.5.18.27.3.21.18.6.14
 29.5.32.20.11.7.13.24.17
 29.6.12.31.20.23.32.20
 29.9.25.27.15.16.32.26.6.32
 3.1.13.22.24.14.12.31.3.4
 3.1.14.8.9.16.30.22.20
 3.10
 3.10.27.4.5.6.19.12.28.12
 3.10.4.5.28.11
 3.11.18.21.5.20.30
 3.11.32.11.22.3.7.17.8.13.23
 3.13
 3.14.1.14.17.28.29.16
 3.14.11.15.21.32.2.15.13
 3.14.30.5.32.22.29
 3.15.2.23.22.2.16.14
 3.18
 3.18.18
 3.18.8.22.7.28.32.31.3
 3.19.11.6.5
 3.20.16.13.29.20
 3.20.19.10.17.27.3.6.22.23
 3.21.16.24.23.12.16.32.3
 3.21.6.13.12.18.25
 3.22.18.1.5.14.9.6.14
 3.25
 3.26
 3.26.32
 3.27.18.8.4.21.6.32.30.7.5
 3.29.19.2.24
 3.29.32.26.8.10.25
 3.3
 3.32.2.29.3.32.28.11.29.30
 3.4.22.19
 3.5
 3.6.24.21.20.32.3.4.26.5
 3.9.11.23.32.26.24.28
 3.9.25.26.7
 30.12.28.2
 30.12.6.30
 30.12.9.25.24.6.7.24.29
 30.15
 30.16.14.9.5.4.10.7.31
 30.16.3.21.10
 30.17.2.25
 30.17.25.3.31.11.3.4.1.10
 30.17.4.5.13.6
 30.18.30.16.29
 30.2.17.8.14
 30.20.3.2.5.15.8.7.17
 30.22.29.21.19.14.3.2.6
 30.23.10.1.10.7.22.28.18.11.17
 30.23.2.13.14.15.29.19.4.12.24
 30.24
 30.24.23.25.32.18.22.12.29.9.22
 30.24.32.15.14.10.11
 30.25
 30.25.17.17.10.29
 30.25.24.22
 30.25.8.24.6.29.31
 30.27.8.6.11.19
 30.3.16.26.7.27.26.9.27.21.18
 30.30.17.5.30.21.19.5.22.22.14
 30.31.13.9
 30.32
 30.4.30.11.13.23.14.24.11
 30.5
 30.6.4
 30.8.18.5.20.6.15
 30.8.9.14.25.30
 30.9.24
 31.13
 31.13.9.1.5.12
 31.17
 31.17.2.30.11
 31.18
 31.18.25.1.14.29.25.5.22.30
 31.18.27.15.20.29.29
 31.18.32.11.7.25.20.5
 31.21.14.20.1.22.2.5.3.27.12
 31.21.22.14.8.21
 31.24.26.18
 31.28.32.4.31.4.7
 31.29.18.26.1.26.17
 31.29.4.29.24.30.30.32.10.23
 31.30.12.20
 31.30.23.7.7.24.32.10.11.1.31
 31.32.12.26.31.32.14.23.28
 31.4.7
 31.5.6.4.8.29.3
 31.7.14.2
 31.9.3.5
 32.1.21.1.16.29.21
 32.1.23.20.14.12.23.5.32.15
 32.1.24.29.22.5.9.24.18.3.13
 32.1.31
 32.15.20.28.5.1.23.4
 32.16
 32.17.8.24.2.14.5.4.22
 32.19.20.24.23.31.8.32.16.29
 32.2.11
 32.24.11.8.12.23.22.19.11.17.18
 32.24.29.6
 32.25.16
 32.25.3.6
 32.27.13.6.7
 32.27.18.7.3.4.2
 32.28.1.32.28.10
 32.29.24.31.25.6.9
 32.3.12.2
 32.3.23.7.2
 32.3.5.9.17.15
 32.30.18.17.1.14.12.18
 32.31.11.22.1
 32.31.26.19.13.29.4.25
 32.4.19
 32.6.13.8.32
 32.6.15.26.14.15.3.19
 32.6.3.2.12.5.28.1.25
 32.6.31.31
 32.6.8
 32.6.9.26.16.4.4.29.7.11
 32.8.29.18.31
 32.8.5
 4.1.24.24.28.24.18
 4.10.28
 4.11.19.17.2.22.20.18.13.32.15
 4.11.22.4.19.24.4.28.6.8.22
 4.13
 4.13.22.11.9.13.27.15.7
 4.14
 4.14.10.19.16
 4.14.16.14.1.8.1.22.17.10
 4.14.17.12.20.17.1.22.3
 4.14.32
 4.15.20.23.12.16.2.16.17
 4.16.22.19.24.21
 4.16.7.25.21.7
 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
(883 rows)

SELECT * FROM ltreetest WHERE t >  '12.3' order by t asc;
                t                 
----------------------------------
 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
 18.7.3.17.13.5.31.6.31.25.29
 18.9.21.2.31.8.32
 18.9.26.7
 19.10.26.19.5.21.30.23
 19.10.4.30.32.4.12
 19.10.8.10.4.19
 19.11.10.18.14.13.7.7
 19.11.29.13.15.27.12.15.14.12
 19.12.20.24.32.13.11.23.26
 19.12.26.24.29.3
 19.12.30.2.21
 19.15.26.19
 19.16.26.2
 19.16.31.31.29.12
 19.17.12.15
 19.17.13.12.32.16.3
 19.19.25.22.11.6.15.3.2.19
 19.2.26.21.16.11.2.2
 19.2.9.29.6
 19.20.25.7.27.28.27.17.9.3.1
 19.22.21.13.27.13.15
 19.22.29.32.1.21.26.24.23.17
 19.26.24.27.6.24.16.27.32.29
 19.26.32.13.1.12.30.26.22.25
 19.3.12.12
 19.3.23.4.4.21.23
 19.30.18.11.32.14
 19.30.27.26.21.7.18
 19.31.14.25.5.8.21.11.13.20
 19.5.20.3.4.2.3
 19.6.13.14.22.13.9.29
 19.6.24.32.30.13.6.25.8.28
 19.7
 19.7.29.31.3.20.7.21.25.27.29
 19.9.32.23.13.24.1
 2.1.12.19.29.28.3.31.28.28.10
 2.1.3.30.24.17.9
 2.10.10.4.20.1.12.13
 2.10.28.1.17.19.32.28
 2.11.32.25.23
 2.12.14.28.16.21
 2.12.30.22.12
 2.13.9.23.21.2
 2.13.9.28
 2.14.10.4.17.17.8.4.27.20
 2.14.12.13
 2.15.14.20.30.26
 2.15.18.21.5.21.4.7.30
 2.16.3.7.22.18.29.20
 2.19.4.1.15.7.8.9.17.29
 2.2.18.18.3.3.18.8.10.8
 2.22.19
 2.24.4.5.24.32
 2.24.5.3.4.10.27.26.17.28.16
 2.27.15.14
 2.28.5.17.6.32
 2.30.26.10.14.31.18.2
 2.31.25
 2.32.10.13.12
 2.32.8.28.24.20.9.24.25.8.9
 2.4.25.32.16.22.26.13.17.18
 2.6.15.26.23.26.24
 2.8.13.12.17.23.16.7.11.23
 2.9
 20.1.24.3.30.31
 20.13
 20.14.11.2.10.14
 20.15
 20.17.14.7
 20.17.18.21.1
 20.18.24.14.12.13.9
 20.20.32.29.24.5.5.26.22.32
 20.20.7
 20.22.10
 20.23.29.5.7.30.13.14.22
 20.23.7.11.11.31.18.16.3
 20.24.14.15.4.21.12.27.4.12
 20.25.22.19.22
 20.28.22.7.10.28.27.22.14.16
 20.29.18.16.2.21.23.11
 20.3.1.8.8.30.20
 20.30.17
 20.30.28.15.17
 20.30.9.9.14.12.29
 20.31.13.12.19.2.26.16.16.22.28
 20.32.5.1.3.20.3.30.27
 20.32.9
 20.4.1.16.31.3
 20.4.27.31.1
 20.5.4.9.31.14.26.6
 20.6.26.3.30
 20.6.3.26.7.29.28.4
 20.8.19.14.16.7
 20.9.29.32.13.7.23
 21.1.4.9.9.31.24.21.3.29
 21.10.20.9.3.16.9.10.20
 21.14
 21.14.13
 21.14.22.29
 21.14.25.20.13.31.14.20
 21.15.18.18.30.3.20
 21.15.31.24.29.24.26.12.20
 21.17.18.32.7.8
 21.17.27.23.15
 21.17.31.10.31.13.9.26.6.14
 21.18
 21.18.2.1
 21.18.30.19.24.24
 21.20.24.25.6.26.23
 21.20.28.19.27.9
 21.21.10.27
 21.22.31.24.27
 21.23.13
 21.23.17.8.23.11.8.1
 21.28.17.22.10.27.4.20.2.32
 21.28.24.23.3.11.7.12.22.32
 21.30.19.6.28.1.32.2.14.14
 21.31.31.25.5.30.26
 21.32.13.21
 21.32.13.22.3.13.31.23.14.12.9
 21.4.11.18
 21.4.22.20.24.28.6
 21.5.11.18
 21.5.17.19.15.25.18.21.24.9
 21.6.22.28.12.23.11.22
 21.7.23.9.16.5.18.14
 21.7.7.11
 21.8.9
 21.9.27.22.32
 21.9.32.1.27
 22.10.12.23.9
 22.10.16.8
 22.10.18
 22.10.27.19.29.20.29.3.12.14.25
 22.11
 22.12.22.28
 22.13.22.21.25.17.8
 22.13.22.8.30.32.10.24
 22.15
 22.16
 22.16.25.18.25.7.24.29.14.8
 22.17.24.14.21.15.12.18.17.25.11
 22.17.30
 22.17.4.2.22.17
 22.17.7.30.13.24
 22.17.9.11.25.15.3.9
 22.18.20.23.15.9.12
 22.19.20.5.2.20
 22.19.21.11.6.8.29.24
 22.19.5.22.20.31.23.24.14.24.4
 22.20.30
 22.21.32.15.8.29.5.12.10.29
 22.22.10.30.5.15.25.21.19.11
 22.22.27.6.27.15.5.18.21.28.9
 22.23.18.18.9.8.23.7.23.23.16
 22.23.22.30
 22.23.25.28.5.27.9.9.24.31.10
 22.24.22.25.15.23.13
 22.25.4.28.9.20.12.13
 22.26.1.28.9.9.31
 22.26.32
 22.28.20.6.32.32
 22.29.18.32.13.12.22.31.17.22
 22.29.29.11
 22.3.6
 22.30
 22.30.31.24.23.22.5.20.28.1
 22.31.2.32.32.11.26.23.19
 22.31.21.13.13.26.11.5.19
 22.32.6.6.3.8.24.6.25.29
 22.8.20.1.10.28.6.27
 22.9.15.19.12
 23.1.23.18.12.29
 23.10.13.32.14.20.16.11.14
 23.10.5.26.12.4.20.4
 23.12.1.5.32.25.8.24.1.25
 23.12.11.11.15.16.22.31.32.5.8
 23.12.19.25.16.23.22.6.29.4
 23.12.32.22.19.1.22.4
 23.14.12.30.18.4.16.18.7.7
 23.14.30.27.28.26.26.23.8.32
 23.17.22.1.23.4.29.32.4.1
 23.17.25.4.1.16.29.10
 23.17.28.31.28
 23.17.32.15.23.16.25
 23.19.17.31.29.13.1.12.5.25
 23.2.22.7.32.3.27.6
 23.20.12.16.15.2
 23.20.24
 23.20.8
 23.22.10.1.14.24
 23.22.23.14.31.32
 23.23
 23.24.11.31.10.31.18.28.13.18.6
 23.24.16.32.13.29
 23.25.23.11.7.23
 23.27.27.16
 23.27.6.26.22
 23.28.1
 23.28.20.25.30.24.15
 23.28.3.30.15.31.32.3.21.9.19
 23.3.20.24
 23.3.32.21.5.14.10.17.1
 23.31.27.16.8.30.20.27
 23.32.5.25.19.9.15.17.15.11
 23.5.5.17
 23.5.7.12.11.23.10
 23.6.27
 23.8.13.22.21
 24.1.10.20.28.18.6.27.20.30.26
 24.1.29.32.14.15.32.6.15.22
 24.10.10.31.4.29.9
 24.10.8.25.16
 24.11.5
 24.12
 24.13.1.8
 24.15.15.17.22
 24.16.27.10.9
 24.17.24
 24.17.31.20.12.9.19.29.18
 24.18.16
 24.2.26.24.14.15.31.23.17.26
 24.2.6.7.16.7.28
 24.20.23
 24.21.14.25.11.3.20.6.6.16
 24.23.24.4.15.25.17
 24.23.29.8.24.11.21.10.28.14.27
 24.24
 24.25.7.27.30.8.26.17
 24.27.14
 24.27.18.32.14.9.11.28.9
 24.28.13.26.8.8.31
 24.28.32.21
 24.3.23.25
 24.31
 24.31.2.13.5.23.18.16
 24.31.8
 24.32.17.23.24.19.23.9.20.18
 24.32.27
 24.9
 24.9.15.1.14.29.6.4
 24.9.27.16.20.21
 24.9.8.12.29
 25.10
 25.10.29.3.6.21.3.31.13
 25.10.4.28.3.31.19
 25.11.24
 25.14.5.32.25
 25.15.11
 25.16.9.6
 25.17.18.17.27
 25.17.18.30
 25.17.2.20.20.3.29.21.3.12
 25.17.9.16.17.31.23.29.24
 25.18.8.3.23.23.5.9.6
 25.19.27.2.9.20
 25.2.11.20.8.6.22
 25.2.3.15.11.19.5.28.25.14
 25.21.8.17
 25.22.2.25.6
 25.24.2.32.14.18.16
 25.24.29
 25.28.3
 25.28.30.24
 25.29
 25.3
 25.30.1.4.24.11
 25.31
 25.32.24.24.28.15.16.10
 25.4.32
 25.4.4.1.13.32.26.20.20.3
 25.5.30.7.16.12.21.12.11.16
 25.6
 25.6.12.16.1
 25.7.3.21.31.12.28
 25.9
 25.9.1.5.9.11.25.4.11.27.32
 25.9.10
 26.11
 26.12.27.2
 26.13.4.7.13.11.3
 26.14
 26.14.5.32.10
 26.16.12
 26.16.12.3.27.9.28
 26.17.9.13.4.25.32.2.24.9
 26.18
 26.18.32.20
 26.19.3.14.8.28.31.10
 26.24
 26.24.9.12.11.15.31.2
 26.25.10.10.13
 26.25.24
 26.26.22.21.14.11.29.19.14.24
 26.28.14
 26.31.11.23.3
 26.31.16.18.22.13.32.23.9.20
 26.31.6.8.29.8.24
 26.31.7
 26.32.21.31.27.12
 26.32.8.12.30.19.24.8.6.1.10
 26.5.29.7.28
 26.7.22.3.18.21.11
 26.7.5.8.11.9.22.1.6
 26.8.28
 26.9.17.1.18.19.1.11.18.29.3
 26.9.20.12.22.22.32
 27.1.11.3.25.9.6.6
 27.11.14.17.24
 27.11.15.9.24.31.18.4.1.30.20
 27.12.4.2.29.22.15
 27.15.15.15
 27.16
 27.17.15.7.28.20
 27.17.17.19.24.9.14.20
 27.17.3.18.2.13.18
 27.18
 27.18.10.4.22
 27.19.20.1.31.29.5.22.26.3
 27.2.10.4.25.14.2.15.4
 27.21.27.5.13.30.17
 27.21.28.24.7.2.24.23.8
 27.22.11.13.21.25.5.1.27.21.27
 27.23.2.32.11.21
 27.23.20.30.7
 27.24.11.31.21.6.29.17.24.18
 27.25
 27.26.29
 27.27
 27.27.25.10.31.10.21.22.21.16.12
 27.27.30.11.15.24.9.7.4.30
 27.29.1.5.30.6.22.16.23.2.28
 27.3
 27.3.3.11.21.4.25
 27.30.12.11.20.15.11.13
 27.31.2.16.29.6
 27.32.26.21.31.17.32.32
 27.4
 27.4.15.14.19.6.12
 27.4.17.17.32.8.16.15.17.13
 27.5.15.1.15.16.21
 27.5.22
 27.6.13.24.21.27.28.22.3.7.4
 28.1.3
 28.11.11.30.20.11.32
 28.11.27.21.14.16
 28.14.24.26.6.15.16.32.25.13.8
 28.14.32.29.2.3.4
 28.15.18.27
 28.15.25.7.13.6.19.2
 28.17.26.9
 28.18.6.22.13.8.25
 28.2.27.1.20
 28.20.8.9.9.28.30.29
 28.23.2.30.3.8.1.15.15.14.13
 28.25.10.25.19.15
 28.25.11.22
 28.25.29.4.13.5.6
 28.26.25.7
 28.26.26.6.31
 28.26.4.22.13.20.32.27.15
 28.27.24.14
 28.28
 28.30.24.16.17.28.2.13.10
 28.31.10.28.22.26.16.15
 28.4
 28.5.12.9.2.27.11.11.2
 28.5.13
 28.6
 28.6.11.6.15.22.12.6
 28.6.8.22.25
 28.8.21.15.16.28.4.16.26.8
 28.9.3.16.17.21.23.30
 29.1
 29.1.2.14.14
 29.1.7.26.25.11.22
 29.10.12.17.12.16
 29.10.17.11.28.12.18.5.19.15.21
 29.11.20.22.27
 29.14.12.9.17.5.32
 29.14.31.25.7.32.23
 29.15.29.8.31.26.1
 29.20.1.11.21.16.1.2.14.28
 29.23.1.21.31.8
 29.23.15.25.1.6.6.10
 29.25.29.16.32.11.15.25.5.22.3
 29.25.30.15.21.3.25.26.26
 29.26.25.14.24.18.2.13.23.29
 29.27
 29.27.13.29.10.2
 29.27.13.9.28.29.19.13.29.31.27
 29.27.5.22.26
 29.27.7.7.3.11.14.26.21.11
 29.28.9.15.8.27.31
 29.29.17.31
 29.29.18
 29.3.15.17.12.29
 29.3.17.17.18.32
 29.30.21.8.16.23.32
 29.30.7.31.22
 29.32.13.4.1.16.20
 29.5.18.27.3.21.18.6.14
 29.5.32.20.11.7.13.24.17
 29.6.12.31.20.23.32.20
 29.9.25.27.15.16.32.26.6.32
 3.1.13.22.24.14.12.31.3.4
 3.1.14.8.9.16.30.22.20
 3.10
 3.10.27.4.5.6.19.12.28.12
 3.10.4.5.28.11
 3.11.18.21.5.20.30
 3.11.32.11.22.3.7.17.8.13.23
 3.13
 3.14.1.14.17.28.29.16
 3.14.11.15.21.32.2.15.13
 3.14.30.5.32.22.29
 3.15.2.23.22.2.16.14
 3.18
 3.18.18
 3.18.8.22.7.28.32.31.3
 3.19.11.6.5
 3.20.16.13.29.20
 3.20.19.10.17.27.3.6.22.23
 3.21.16.24.23.12.16.32.3
 3.21.6.13.12.18.25
 3.22.18.1.5.14.9.6.14
 3.25
 3.26
 3.26.32
 3.27.18.8.4.21.6.32.30.7.5
 3.29.19.2.24
 3.29.32.26.8.10.25
 3.3
 3.32.2.29.3.32.28.11.29.30
 3.4.22.19
 3.5
 3.6.24.21.20.32.3.4.26.5
 3.9.11.23.32.26.24.28
 3.9.25.26.7
 30.12.28.2
 30.12.6.30
 30.12.9.25.24.6.7.24.29
 30.15
 30.16.14.9.5.4.10.7.31
 30.16.3.21.10
 30.17.2.25
 30.17.25.3.31.11.3.4.1.10
 30.17.4.5.13.6
 30.18.30.16.29
 30.2.17.8.14
 30.20.3.2.5.15.8.7.17
 30.22.29.21.19.14.3.2.6
 30.23.10.1.10.7.22.28.18.11.17
 30.23.2.13.14.15.29.19.4.12.24
 30.24
 30.24.23.25.32.18.22.12.29.9.22
 30.24.32.15.14.10.11
 30.25
 30.25.17.17.10.29
 30.25.24.22
 30.25.8.24.6.29.31
 30.27.8.6.11.19
 30.3.16.26.7.27.26.9.27.21.18
 30.30.17.5.30.21.19.5.22.22.14
 30.31.13.9
 30.32
 30.4.30.11.13.23.14.24.11
 30.5
 30.6.4
 30.8.18.5.20.6.15
 30.8.9.14.25.30
 30.9.24
 31.13
 31.13.9.1.5.12
 31.17
 31.17.2.30.11
 31.18
 31.18.25.1.14.29.25.5.22.30
 31.18.27.15.20.29.29
 31.18.32.11.7.25.20.5
 31.21.14.20.1.22.2.5.3.27.12
 31.21.22.14.8.21
 31.24.26.18
 31.28.32.4.31.4.7
 31.29.18.26.1.26.17
 31.29.4.29.24.30.30.32.10.23
 31.30.12.20
 31.30.23.7.7.24.32.10.11.1.31
 31.32.12.26.31.32.14.23.28
 31.4.7
 31.5.6.4.8.29.3
 31.7.14.2
 31.9.3.5
 32.1.21.1.16.29.21
 32.1.23.20.14.12.23.5.32.15
 32.1.24.29.22.5.9.24.18.3.13
 32.1.31
 32.15.20.28.5.1.23.4
 32.16
 32.17.8.24.2.14.5.4.22
 32.19.20.24.23.31.8.32.16.29
 32.2.11
 32.24.11.8.12.23.22.19.11.17.18
 32.24.29.6
 32.25.16
 32.25.3.6
 32.27.13.6.7
 32.27.18.7.3.4.2
 32.28.1.32.28.10
 32.29.24.31.25.6.9
 32.3.12.2
 32.3.23.7.2
 32.3.5.9.17.15
 32.30.18.17.1.14.12.18
 32.31.11.22.1
 32.31.26.19.13.29.4.25
 32.4.19
 32.6.13.8.32
 32.6.15.26.14.15.3.19
 32.6.3.2.12.5.28.1.25
 32.6.31.31
 32.6.8
 32.6.9.26.16.4.4.29.7.11
 32.8.29.18.31
 32.8.5
 4.1.24.24.28.24.18
 4.10.28
 4.11.19.17.2.22.20.18.13.32.15
 4.11.22.4.19.24.4.28.6.8.22
 4.13
 4.13.22.11.9.13.27.15.7
 4.14
 4.14.10.19.16
 4.14.16.14.1.8.1.22.17.10
 4.14.17.12.20.17.1.22.3
 4.14.32
 4.15.20.23.12.16.2.16.17
 4.16.22.19.24.21
 4.16.7.25.21.7
 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
 18.7.3.17.13.5.31.6.31.25.29
 18.9.21.2.31.8.32
 18.9.26.7
 19.10.26.19.5.21.30.23
 19.10.4.30.32.4.12
 19.10.8.10.4.19
 19.11.10.18.14.13.7.7
 19.11.29.13.15.27.12.15.14.12
 19.12.20.24.32.13.11.23.26
 19.12.26.24.29.3
 19.12.30.2.21
 19.15.26.19
 19.16.26.2
 19.16.31.31.29.12
 19.17.12.15
 19.17.13.12.32.16.3
 19.19.25.22.11.6.15.3.2.19
 19.2.26.21.16.11.2.2
 19.2.9.29.6
 19.20.25.7.27.28.27.17.9.3.1
 19.22.21.13.27.13.15
 19.22.29.32.1.21.26.24.23.17
 19.26.24.27.6.24.16.27.32.29
 19.26.32.13.1.12.30.26.22.25
 19.3.12.12
 19.3.23.4.4.21.23
 19.30.18.11.32.14
 19.30.27.26.21.7.18
 19.31.14.25.5.8.21.11.13.20
 19.5.20.3.4.2.3
 19.6.13.14.22.13.9.29
 19.6.24.32.30.13.6.25.8.28
 19.7
 19.7.29.31.3.20.7.21.25.27.29
 19.9.32.23.13.24.1
 2.1.12.19.29.28.3.31.28.28.10
 2.1.3.30.24.17.9
 2.10.10.4.20.1.12.13
 2.10.28.1.17.19.32.28
 2.11.32.25.23
 2.12.14.28.16.21
 2.12.30.22.12
 2.13.9.23.21.2
 2.13.9.28
 2.14.10.4.17.17.8.4.27.20
 2.14.12.13
 2.15.14.20.30.26
 2.15.18.21.5.21.4.7.30
 2.16.3.7.22.18.29.20
 2.19.4.1.15.7.8.9.17.29
 2.2.18.18.3.3.18.8.10.8
 2.22.19
 2.24.4.5.24.32
 2.24.5.3.4.10.27.26.17.28.16
 2.27.15.14
 2.28.5.17.6.32
 2.30.26.10.14.31.18.2
 2.31.25
 2.32.10.13.12
 2.32.8.28.24.20.9.24.25.8.9
 2.4.25.32.16.22.26.13.17.18
 2.6.15.26.23.26.24
 2.8.13.12.17.23.16.7.11.23
 2.9
 20.1.24.3.30.31
 20.13
 20.14.11.2.10.14
 20.15
 20.17.14.7
 20.17.18.21.1
 20.18.24.14.12.13.9
 20.20.32.29.24.5.5.26.22.32
 20.20.7
 20.22.10
 20.23.29.5.7.30.13.14.22
 20.23.7.11.11.31.18.16.3
 20.24.14.15.4.21.12.27.4.12
 20.25.22.19.22
 20.28.22.7.10.28.27.22.14.16
 20.29.18.16.2.21.23.11
 20.3.1.8.8.30.20
 20.30.17
 20.30.28.15.17
 20.30.9.9.14.12.29
 20.31.13.12.19.2.26.16.16.22.28
 20.32.5.1.3.20.3.30.27
 20.32.9
 20.4.1.16.31.3
 20.4.27.31.1
 20.5.4.9.31.14.26.6
 20.6.26.3.30
 20.6.3.26.7.29.28.4
 20.8.19.14.16.7
 20.9.29.32.13.7.23
 21.1.4.9.9.31.24.21.3.29
 21.10.20.9.3.16.9.10.20
 21.14
 21.14.13
 21.14.22.29
 21.14.25.20.13.31.14.20
 21.15.18.18.30.3.20
 21.15.31.24.29.24.26.12.20
 21.17.18.32.7.8
 21.17.27.23.15
 21.17.31.10.31.13.9.26.6.14
 21.18
 21.18.2.1
 21.18.30.19.24.24
 21.20.24.25.6.26.23
 21.20.28.19.27.9
 21.21.10.27
 21.22.31.24.27
 21.23.13
 21.23.17.8.23.11.8.1
 21.28.17.22.10.27.4.20.2.32
 21.28.24.23.3.11.7.12.22.32
 21.30.19.6.28.1.32.2.14.14
 21.31.31.25.5.30.26
 21.32.13.21
 21.32.13.22.3.13.31.23.14.12.9
 21.4.11.18
 21.4.22.20.24.28.6
 21.5.11.18
 21.5.17.19.15.25.18.21.24.9
 21.6.22.28.12.23.11.22
 21.7.23.9.16.5.18.14
 21.7.7.11
 21.8.9
 21.9.27.22.32
 21.9.32.1.27
 22.10.12.23.9
 22.10.16.8
 22.10.18
 22.10.27.19.29.20.29.3.12.14.25
 22.11
 22.12.22.28
 22.13.22.21.25.17.8
 22.13.22.8.30.32.10.24
 22.15
 22.16
 22.16.25.18.25.7.24.29.14.8
 22.17.24.14.21.15.12.18.17.25.11
 22.17.30
 22.17.4.2.22.17
 22.17.7.30.13.24
 22.17.9.11.25.15.3.9
 22.18.20.23.15.9.12
 22.19.20.5.2.20
 22.19.21.11.6.8.29.24
 22.19.5.22.20.31.23.24.14.24.4
 22.20.30
 22.21.32.15.8.29.5.12.10.29
 22.22.10.30.5.15.25.21.19.11
 22.22.27.6.27.15.5.18.21.28.9
 22.23.18.18.9.8.23.7.23.23.16
 22.23.22.30
 22.23.25.28.5.27.9.9.24.31.10
 22.24.22.25.15.23.13
 22.25.4.28.9.20.12.13
 22.26.1.28.9.9.31
 22.26.32
 22.28.20.6.32.32
 22.29.18.32.13.12.22.31.17.22
 22.29.29.11
 22.3.6
 22.30
 22.30.31.24.23.22.5.20.28.1
 22.31.2.32.32.11.26.23.19
 22.31.21.13.13.26.11.5.19
 22.32.6.6.3.8.24.6.25.29
 22.8.20.1.10.28.6.27
 22.9.15.19.12
 23.1.23.18.12.29
 23.10.13.32.14.20.16.11.14
 23.10.5.26.12.4.20.4
 23.12.1.5.32.25.8.24.1.25
 23.12.11.11.15.16.22.31.32.5.8
 23.12.19.25.16.23.22.6.29.4
 23.12.32.22.19.1.22.4
 23.14.12.30.18.4.16.18.7.7
 23.14.30.27.28.26.26.23.8.32
 23.17.22.1.23.4.29.32.4.1
 23.17.25.4.1.16.29.10
 23.17.28.31.28
 23.17.32.15.23.16.25
 23.19.17.31.29.13.1.12.5.25
 23.2.22.7.32.3.27.6
 23.20.12.16.15.2
 23.20.24
 23.20.8
 23.22.10.1.14.24
 23.22.23.14.31.32
 23.23
 23.24.11.31.10.31.18.28.13.18.6
 23.24.16.32.13.29
 23.25.23.11.7.23
 23.27.27.16
 23.27.6.26.22
 23.28.1
 23.28.20.25.30.24.15
 23.28.3.30.15.31.32.3.21.9.19
 23.3.20.24
 23.3.32.21.5.14.10.17.1
 23.31.27.16.8.30.20.27
 23.32.5.25.19.9.15.17.15.11
 23.5.5.17
 23.5.7.12.11.23.10
 23.6.27
 23.8.13.22.21
 24.1.10.20.28.18.6.27.20.30.26
 24.1.29.32.14.15.32.6.15.22
 24.10.10.31.4.29.9
 24.10.8.25.16
 24.11.5
 24.12
 24.13.1.8
 24.15.15.17.22
 24.16.27.10.9
 24.17.24
 24.17.31.20.12.9.19.29.18
 24.18.16
 24.2.26.24.14.15.31.23.17.26
 24.2.6.7.16.7.28
 24.20.23
 24.21.14.25.11.3.20.6.6.16
 24.23.24.4.15.25.17
 24.23.29.8.24.11.21.10.28.14.27
 24.24
 24.25.7.27.30.8.26.17
 24.27.14
 24.27.18.32.14.9.11.28.9
 24.28.13.26.8.8.31
 24.28.32.21
 24.3.23.25
 24.31
 24.31.2.13.5.23.18.16
 24.31.8
 24.32.17.23.24.19.23.9.20.18
 24.32.27
 24.9
 24.9.15.1.14.29.6.4
 24.9.27.16.20.21
 24.9.8.12.29
 25.10
 25.10.29.3.6.21.3.31.13
 25.10.4.28.3.31.19
 25.11.24
 25.14.5.32.25
 25.15.11
 25.16.9.6
 25.17.18.17.27
 25.17.18.30
 25.17.2.20.20.3.29.21.3.12
 25.17.9.16.17.31.23.29.24
 25.18.8.3.23.23.5.9.6
 25.19.27.2.9.20
 25.2.11.20.8.6.22
 25.2.3.15.11.19.5.28.25.14
 25.21.8.17
 25.22.2.25.6
 25.24.2.32.14.18.16
 25.24.29
 25.28.3
 25.28.30.24
 25.29
 25.3
 25.30.1.4.24.11
 25.31
 25.32.24.24.28.15.16.10
 25.4.32
 25.4.4.1.13.32.26.20.20.3
 25.5.30.7.16.12.21.12.11.16
 25.6
 25.6.12.16.1
 25.7.3.21.31.12.28
 25.9
 25.9.1.5.9.11.25.4.11.27.32
 25.9.10
 26.11
 26.12.27.2
 26.13.4.7.13.11.3
 26.14
 26.14.5.32.10
 26.16.12
 26.16.12.3.27.9.28
 26.17.9.13.4.25.32.2.24.9
 26.18
 26.18.32.20
 26.19.3.14.8.28.31.10
 26.24
 26.24.9.12.11.15.31.2
 26.25.10.10.13
 26.25.24
 26.26.22.21.14.11.29.19.14.24
 26.28.14
 26.31.11.23.3
 26.31.16.18.22.13.32.23.9.20
 26.31.6.8.29.8.24
 26.31.7
 26.32.21.31.27.12
 26.32.8.12.30.19.24.8.6.1.10
 26.5.29.7.28
 26.7.22.3.18.21.11
 26.7.5.8.11.9.22.1.6
 26.8.28
 26.9.17.1.18.19.1.11.18.29.3
 26.9.20.12.22.22.32
 27.1.11.3.25.9.6.6
 27.11.14.17.24
 27.11.15.9.24.31.18.4.1.30.20
 27.12.4.2.29.22.15
 27.15.15.15
 27.16
 27.17.15.7.28.20
 27.17.17.19.24.9.14.20
 27.17.3.18.2.13.18
 27.18
 27.18.10.4.22
 27.19.20.1.31.29.5.22.26.3
 27.2.10.4.25.14.2.15.4
 27.21.27.5.13.30.17
 27.21.28.24.7.2.24.23.8
 27.22.11.13.21.25.5.1.27.21.27
 27.23.2.32.11.21
 27.23.20.30.7
 27.24.11.31.21.6.29.17.24.18
 27.25
 27.26.29
 27.27
 27.27.25.10.31.10.21.22.21.16.12
 27.27.30.11.15.24.9.7.4.30
 27.29.1.5.30.6.22.16.23.2.28
 27.3
 27.3.3.11.21.4.25
 27.30.12.11.20.15.11.13
 27.31.2.16.29.6
 27.32.26.21.31.17.32.32
 27.4
 27.4.15.14.19.6.12
 27.4.17.17.32.8.16.15.17.13
 27.5.15.1.15.16.21
 27.5.22
 27.6.13.24.21.27.28.22.3.7.4
 28.1.3
 28.11.11.30.20.11.32
 28.11.27.21.14.16
 28.14.24.26.6.15.16.32.25.13.8
 28.14.32.29.2.3.4
 28.15.18.27
 28.15.25.7.13.6.19.2
 28.17.26.9
 28.18.6.22.13.8.25
 28.2.27.1.20
 28.20.8.9.9.28.30.29
 28.23.2.30.3.8.1.15.15.14.13
 28.25.10.25.19.15
 28.25.11.22
 28.25.29.4.13.5.6
 28.26.25.7
 28.26.26.6.31
 28.26.4.22.13.20.32.27.15
 28.27.24.14
 28.28
 28.30.24.16.17.28.2.13.10
 28.31.10.28.22.26.16.15
 28.4
 28.5.12.9.2.27.11.11.2
 28.5.13
 28.6
 28.6.11.6.15.22.12.6
 28.6.8.22.25
 28.8.21.15.16.28.4.16.26.8
 28.9.3.16.17.21.23.30
 29.1
 29.1.2.14.14
 29.1.7.26.25.11.22
 29.10.12.17.12.16
 29.10.17.11.28.12.18.5.19.15.21
 29.11.20.22.27
 29.14.12.9.17.5.32
 29.14.31.25.7.32.23
 29.15.29.8.31.26.1
 29.20.1.11.21.16.1.2.14.28
 29.23.1.21.31.8
 29.23.15.25.1.6.6.10
 29.25.29.16.32.11.15.25.5.22.3
 29.25.30.15.21.3.25.26.26
 29.26.25.14.24.18.2.13.23.29
 29.27
 29.27.13.29.10.2
 29.27.13.9.28.29.19.13.29.31.27
 29.27.5.22.26
 29.27.7.7.3.11.14.26.21.11
 29.28.9.15.8.27.31
 29.29.17.31
 29.29.18
 29.3.15.17.12.29
 29.3.17.17.18.32
 29.30.21.8.16.23.32
 29.30.7.31.22
 29.32.13.4.1.16.20
 29.5.18.27.3.21.18.6.14
 29.5.32.20.11.7.13.24.17
 29.6.12.31.20.23.32.20
 29.9.25.27.15.16.32.26.6.32
 3.1.13.22.24.14.12.31.3.4
 3.1.14.8.9.16.30.22.20
 3.10
 3.10.27.4.5.6.19.12.28.12
 3.10.4.5.28.11
 3.11.18.21.5.20.30
 3.11.32.11.22.3.7.17.8.13.23
 3.13
 3.14.1.14.17.28.29.16
 3.14.11.15.21.32.2.15.13
 3.14.30.5.32.22.29
 3.15.2.23.22.2.16.14
 3.18
 3.18.18
 3.18.8.22.7.28.32.31.3
 3.19.11.6.5
 3.20.16.13.29.20
 3.20.19.10.17.27.3.6.22.23
 3.21.16.24.23.12.16.32.3
 3.21.6.13.12.18.25
 3.22.18.1.5.14.9.6.14
 3.25
 3.26
 3.26.32
 3.27.18.8.4.21.6.32.30.7.5
 3.29.19.2.24
 3.29.32.26.8.10.25
 3.3
 3.32.2.29.3.32.28.11.29.30
 3.4.22.19
 3.5
 3.6.24.21.20.32.3.4.26.5
 3.9.11.23.32.26.24.28
 3.9.25.26.7
 30.12.28.2
 30.12.6.30
 30.12.9.25.24.6.7.24.29
 30.15
 30.16.14.9.5.4.10.7.31
 30.16.3.21.10
 30.17.2.25
 30.17.25.3.31.11.3.4.1.10
 30.17.4.5.13.6
 30.18.30.16.29
 30.2.17.8.14
 30.20.3.2.5.15.8.7.17
 30.22.29.21.19.14.3.2.6
 30.23.10.1.10.7.22.28.18.11.17
 30.23.2.13.14.15.29.19.4.12.24
 30.24
 30.24.23.25.32.18.22.12.29.9.22
 30.24.32.15.14.10.11
 30.25
 30.25.17.17.10.29
 30.25.24.22
 30.25.8.24.6.29.31
 30.27.8.6.11.19
 30.3.16.26.7.27.26.9.27.21.18
 30.30.17.5.30.21.19.5.22.22.14
 30.31.13.9
 30.32
 30.4.30.11.13.23.14.24.11
 30.5
 30.6.4
 30.8.18.5.20.6.15
 30.8.9.14.25.30
 30.9.24
 31.13
 31.13.9.1.5.12
 31.17
 31.17.2.30.11
 31.18
 31.18.25.1.14.29.25.5.22.30
 31.18.27.15.20.29.29
 31.18.32.11.7.25.20.5
 31.21.14.20.1.22.2.5.3.27.12
 31.21.22.14.8.21
 31.24.26.18
 31.28.32.4.31.4.7
 31.29.18.26.1.26.17
 31.29.4.29.24.30.30.32.10.23
 31.30.12.20
 31.30.23.7.7.24.32.10.11.1.31
 31.32.12.26.31.32.14.23.28
 31.4.7
 31.5.6.4.8.29.3
 31.7.14.2
 31.9.3.5
 32.1.21.1.16.29.21
 32.1.23.20.14.12.23.5.32.15
 32.1.24.29.22.5.9.24.18.3.13
 32.1.31
 32.15.20.28.5.1.23.4
 32.16
 32.17.8.24.2.14.5.4.22
 32.19.20.24.23.31.8.32.16.29
 32.2.11
 32.24.11.8.12.23.22.19.11.17.18
 32.24.29.6
 32.25.16
 32.25.3.6
 32.27.13.6.7
 32.27.18.7.3.4.2
 32.28.1.32.28.10
 32.29.24.31.25.6.9
 32.3.12.2
 32.3.23.7.2
 32.3.5.9.17.15
 32.30.18.17.1.14.12.18
 32.31.11.22.1
 32.31.26.19.13.29.4.25
 32.4.19
 32.6.13.8.32
 32.6.15.26.14.15.3.19
 32.6.3.2.12.5.28.1.25
 32.6.31.31
 32.6.8
 32.6.9.26.16.4.4.29.7.11
 32.8.29.18.31
 32.8.5
 4.1.24.24.28.24.18
 4.10.28
 4.11.19.17.2.22.20.18.13.32.15
 4.11.22.4.19.24.4.28.6.8.22
 4.13
 4.13.22.11.9.13.27.15.7
 4.14
 4.14.10.19.16
 4.14.16.14.1.8.1.22.17.10
 4.14.17.12.20.17.1.22.3
 4.14.32
 4.15.20.23.12.16.2.16.17
 4.16.22.19.24.21
 4.16.7.25.21.7
 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
(883 rows)

SELECT * FROM ltreetest WHERE t >  '12.3' order by t asc;
                t                 
----------------------------------
 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
 18.7.3.17.13.5.31.6.31.25.29
 18.9.21.2.31.8.32
 18.9.26.7
 19.10.26.19.5.21.30.23
 19.10.4.30.32.4.12
 19.10.8.10.4.19
 19.11.10.18.14.13.7.7
 19.11.29.13.15.27.12.15.14.12
 19.12.20.24.32.13.11.23.26
 19.12.26.24.29.3
 19.12.30.2.21
 19.15.26.19
 19.16.26.2
 19.16.31.31.29.12
 19.17.12.15
 19.17.13.12.32.16.3
 19.19.25.22.11.6.15.3.2.19
 19.2.26.21.16.11.2.2
 19.2.9.29.6
 19.20.25.7.27.28.27.17.9.3.1
 19.22.21.13.27.13.15
 19.22.29.32.1.21.26.24.23.17
 19.26.24.27.6.24.16.27.32.29
 19.26.32.13.1.12.30.26.22.25
 19.3.12.12
 19.3.23.4.4.21.23
 19.30.18.11.32.14
 19.30.27.26.21.7.18
 19.31.14.25.5.8.21.11.13.20
 19.5.20.3.4.2.3
 19.6.13.14.22.13.9.29
 19.6.24.32.30.13.6.25.8.28
 19.7
 19.7.29.31.3.20.7.21.25.27.29
 19.9.32.23.13.24.1
 2.1.12.19.29.28.3.31.28.28.10
 2.1.3.30.24.17.9
 2.10.10.4.20.1.12.13
 2.10.28.1.17.19.32.28
 2.11.32.25.23
 2.12.14.28.16.21
 2.12.30.22.12
 2.13.9.23.21.2
 2.13.9.28
 2.14.10.4.17.17.8.4.27.20
 2.14.12.13
 2.15.14.20.30.26
 2.15.18.21.5.21.4.7.30
 2.16.3.7.22.18.29.20
 2.19.4.1.15.7.8.9.17.29
 2.2.18.18.3.3.18.8.10.8
 2.22.19
 2.24.4.5.24.32
 2.24.5.3.4.10.27.26.17.28.16
 2.27.15.14
 2.28.5.17.6.32
 2.30.26.10.14.31.18.2
 2.31.25
 2.32.10.13.12
 2.32.8.28.24.20.9.24.25.8.9
 2.4.25.32.16.22.26.13.17.18
 2.6.15.26.23.26.24
 2.8.13.12.17.23.16.7.11.23
 2.9
 20.1.24.3.30.31
 20.13
 20.14.11.2.10.14
 20.15
 20.17.14.7
 20.17.18.21.1
 20.18.24.14.12.13.9
 20.20.32.29.24.5.5.26.22.32
 20.20.7
 20.22.10
 20.23.29.5.7.30.13.14.22
 20.23.7.11.11.31.18.16.3
 20.24.14.15.4.21.12.27.4.12
 20.25.22.19.22
 20.28.22.7.10.28.27.22.14.16
 20.29.18.16.2.21.23.11
 20.3.1.8.8.30.20
 20.30.17
 20.30.28.15.17
 20.30.9.9.14.12.29
 20.31.13.12.19.2.26.16.16.22.28
 20.32.5.1.3.20.3.30.27
 20.32.9
 20.4.1.16.31.3
 20.4.27.31.1
 20.5.4.9.31.14.26.6
 20.6.26.3.30
 20.6.3.26.7.29.28.4
 20.8.19.14.16.7
 20.9.29.32.13.7.23
 21.1.4.9.9.31.24.21.3.29
 21.10.20.9.3.16.9.10.20
 21.14
 21.14.13
 21.14.22.29
 21.14.25.20.13.31.14.20
 21.15.18.18.30.3.20
 21.15.31.24.29.24.26.12.20
 21.17.18.32.7.8
 21.17.27.23.15
 21.17.31.10.31.13.9.26.6.14
 21.18
 21.18.2.1
 21.18.30.19.24.24
 21.20.24.25.6.26.23
 21.20.28.19.27.9
 21.21.10.27
 21.22.31.24.27
 21.23.13
 21.23.17.8.23.11.8.1
 21.28.17.22.10.27.4.20.2.32
 21.28.24.23.3.11.7.12.22.32
 21.30.19.6.28.1.32.2.14.14
 21.31.31.25.5.30.26
 21.32.13.21
 21.32.13.22.3.13.31.23.14.12.9
 21.4.11.18
 21.4.22.20.24.28.6
 21.5.11.18
 21.5.17.19.15.25.18.21.24.9
 21.6.22.28.12.23.11.22
 21.7.23.9.16.5.18.14
 21.7.7.11
 21.8.9
 21.9.27.22.32
 21.9.32.1.27
 22.10.12.23.9
 22.10.16.8
 22.10.18
 22.10.27.19.29.20.29.3.12.14.25
 22.11
 22.12.22.28
 22.13.22.21.25.17.8
 22.13.22.8.30.32.10.24
 22.15
 22.16
 22.16.25.18.25.7.24.29.14.8
 22.17.24.14.21.15.12.18.17.25.11
 22.17.30
 22.17.4.2.22.17
 22.17.7.30.13.24
 22.17.9.11.25.15.3.9
 22.18.20.23.15.9.12
 22.19.20.5.2.20
 22.19.21.11.6.8.29.24
 22.19.5.22.20.31.23.24.14.24.4
 22.20.30
 22.21.32.15.8.29.5.12.10.29
 22.22.10.30.5.15.25.21.19.11
 22.22.27.6.27.15.5.18.21.28.9
 22.23.18.18.9.8.23.7.23.23.16
 22.23.22.30
 22.23.25.28.5.27.9.9.24.31.10
 22.24.22.25.15.23.13
 22.25.4.28.9.20.12.13
 22.26.1.28.9.9.31
 22.26.32
 22.28.20.6.32.32
 22.29.18.32.13.12.22.31.17.22
 22.29.29.11
 22.3.6
 22.30
 22.30.31.24.23.22.5.20.28.1
 22.31.2.32.32.11.26.23.19
 22.31.21.13.13.26.11.5.19
 22.32.6.6.3.8.24.6.25.29
 22.8.20.1.10.28.6.27
 22.9.15.19.12
 23.1.23.18.12.29
 23.10.13.32.14.20.16.11.14
 23.10.5.26.12.4.20.4
 23.12.1.5.32.25.8.24.1.25
 23.12.11.11.15.16.22.31.32.5.8
 23.12.19.25.16.23.22.6.29.4
 23.12.32.22.19.1.22.4
 23.14.12.30.18.4.16.18.7.7
 23.14.30.27.28.26.26.23.8.32
 23.17.22.1.23.4.29.32.4.1
 23.17.25.4.1.16.29.10
 23.17.28.31.28
 23.17.32.15.23.16.25
 23.19.17.31.29.13.1.12.5.25
 23.2.22.7.32.3.27.6
 23.20.12.16.15.2
 23.20.24
 23.20.8
 23.22.10.1.14.24
 23.22.23.14.31.32
 23.23
 23.24.11.31.10.31.18.28.13.18.6
 23.24.16.32.13.29
 23.25.23.11.7.23
 23.27.27.16
 23.27.6.26.22
 23.28.1
 23.28.20.25.30.24.15
 23.28.3.30.15.31.32.3.21.9.19
 23.3.20.24
 23.3.32.21.5.14.10.17.1
 23.31.27.16.8.30.20.27
 23.32.5.25.19.9.15.17.15.11
 23.5.5.17
 23.5.7.12.11.23.10
 23.6.27
 23.8.13.22.21
 24.1.10.20.28.18.6.27.20.30.26
 24.1.29.32.14.15.32.6.15.22
 24.10.10.31.4.29.9
 24.10.8.25.16
 24.11.5
 24.12
 24.13.1.8
 24.15.15.17.22
 24.16.27.10.9
 24.17.24
 24.17.31.20.12.9.19.29.18
 24.18.16
 24.2.26.24.14.15.31.23.17.26
 24.2.6.7.16.7.28
 24.20.23
 24.21.14.25.11.3.20.6.6.16
 24.23.24.4.15.25.17
 24.23.29.8.24.11.21.10.28.14.27
 24.24
 24.25.7.27.30.8.26.17
 24.27.14
 24.27.18.32.14.9.11.28.9
 24.28.13.26.8.8.31
 24.28.32.21
 24.3.23.25
 24.31
 24.31.2.13.5.23.18.16
 24.31.8
 24.32.17.23.24.19.23.9.20.18
 24.32.27
 24.9
 24.9.15.1.14.29.6.4
 24.9.27.16.20.21
 24.9.8.12.29
 25.10
 25.10.29.3.6.21.3.31.13
 25.10.4.28.3.31.19
 25.11.24
 25.14.5.32.25
 25.15.11
 25.16.9.6
 25.17.18.17.27
 25.17.18.30
 25.17.2.20.20.3.29.21.3.12
 25.17.9.16.17.31.23.29.24
 25.18.8.3.23.23.5.9.6
 25.19.27.2.9.20
 25.2.11.20.8.6.22
 25.2.3.15.11.19.5.28.25.14
 25.21.8.17
 25.22.2.25.6
 25.24.2.32.14.18.16
 25.24.29
 25.28.3
 25.28.30.24
 25.29
 25.3
 25.30.1.4.24.11
 25.31
 25.32.24.24.28.15.16.10
 25.4.32
 25.4.4.1.13.32.26.20.20.3
 25.5.30.7.16.12.21.12.11.16
 25.6
 25.6.12.16.1
 25.7.3.21.31.12.28
 25.9
 25.9.1.5.9.11.25.4.11.27.32
 25.9.10
 26.11
 26.12.27.2
 26.13.4.7.13.11.3
 26.14
 26.14.5.32.10
 26.16.12
 26.16.12.3.27.9.28
 26.17.9.13.4.25.32.2.24.9
 26.18
 26.18.32.20
 26.19.3.14.8.28.31.10
 26.24
 26.24.9.12.11.15.31.2
 26.25.10.10.13
 26.25.24
 26.26.22.21.14.11.29.19.14.24
 26.28.14
 26.31.11.23.3
 26.31.16.18.22.13.32.23.9.20
 26.31.6.8.29.8.24
 26.31.7
 26.32.21.31.27.12
 26.32.8.12.30.19.24.8.6.1.10
 26.5.29.7.28
 26.7.22.3.18.21.11
 26.7.5.8.11.9.22.1.6
 26.8.28
 26.9.17.1.18.19.1.11.18.29.3
 26.9.20.12.22.22.32
 27.1.11.3.25.9.6.6
 27.11.14.17.24
 27.11.15.9.24.31.18.4.1.30.20
 27.12.4.2.29.22.15
 27.15.15.15
 27.16
 27.17.15.7.28.20
 27.17.17.19.24.9.14.20
 27.17.3.18.2.13.18
 27.18
 27.18.10.4.22
 27.19.20.1.31.29.5.22.26.3
 27.2.10.4.25.14.2.15.4
 27.21.27.5.13.30.17
 27.21.28.24.7.2.24.23.8
 27.22.11.13.21.25.5.1.27.21.27
 27.23.2.32.11.21
 27.23.20.30.7
 27.24.11.31.21.6.29.17.24.18
 27.25
 27.26.29
 27.27
 27.27.25.10.31.10.21.22.21.16.12
 27.27.30.11.15.24.9.7.4.30
 27.29.1.5.30.6.22.16.23.2.28
 27.3
 27.3.3.11.21.4.25
 27.30.12.11.20.15.11.13
 27.31.2.16.29.6
 27.32.26.21.31.17.32.32
 27.4
 27.4.15.14.19.6.12
 27.4.17.17.32.8.16.15.17.13
 27.5.15.1.15.16.21
 27.5.22
 27.6.13.24.21.27.28.22.3.7.4
 28.1.3
 28.11.11.30.20.11.32
 28.11.27.21.14.16
 28.14.24.26.6.15.16.32.25.13.8
 28.14.32.29.2.3.4
 28.15.18.27
 28.15.25.7.13.6.19.2
 28.17.26.9
 28.18.6.22.13.8.25
 28.2.27.1.20
 28.20.8.9.9.28.30.29
 28.23.2.30.3.8.1.15.15.14.13
 28.25.10.25.19.15
 28.25.11.22
 28.25.29.4.13.5.6
 28.26.25.7
 28.26.26.6.31
 28.26.4.22.13.20.32.27.15
 28.27.24.14
 28.28
 28.30.24.16.17.28.2.13.10
 28.31.10.28.22.26.16.15
 28.4
 28.5.12.9.2.27.11.11.2
 28.5.13
 28.6
 28.6.11.6.15.22.12.6
 28.6.8.22.25
 28.8.21.15.16.28.4.16.26.8
 28.9.3.16.17.21.23.30
 29.1
 29.1.2.14.14
 29.1.7.26.25.11.22
 29.10.12.17.12.16
 29.10.17.11.28.12.18.5.19.15.21
 29.11.20.22.27
 29.14.12.9.17.5.32
 29.14.31.25.7.32.23
 29.15.29.8.31.26.1
 29.20.1.11.21.16.1.2.14.28
 29.23.1.21.31.8
 29.23.15.25.1.6.6.10
 29.25.29.16.32.11.15.25.5.22.3
 29.25.30.15.21.3.25.26.26
 29.26.25.14.24.18.2.13.23.29
 29.27
 29.27.13.29.10.2
 29.27.13.9.28.29.19.13.29.31.27
 29.27.5.22.26
 29.27.7.7.3.11.14.26.21.11
 29.28.9.15.8.27.31
 29.29.17.31
 29.29.18
 29.3.15.17.12.29
 29.3.17.17.18.32
 29.30.21.8.16.23.32
 29.30.7.31.22
 29.32.13.4.1.16.20
 29.5.18.27.3.21.18.6.14
 29.5.32.20.11.7.13.24.17
 29.6.12.31.20.23.32.20
 29.9.25.27.15.16.32.26.6.32
 3.1.13.22.24.14.12.31.3.4
 3.1.14.8.9.16.30.22.20
 3.10
 3.10.27.4.5.6.19.12.28.12
 3.10.4.5.28.11
 3.11.18.21.5.20.30
 3.11.32.11.22.3.7.17.8.13.23
 3.13
 3.14.1.14.17.28.29.16
 3.14.11.15.21.32.2.15.13
 3.14.30.5.32.22.29
 3.15.2.23.22.2.16.14
 3.18
 3.18.18
 3.18.8.22.7.28.32.31.3
 3.19.11.6.5
 3.20.16.13.29.20
 3.20.19.10.17.27.3.6.22.23
 3.21.16.24.23.12.16.32.3
 3.21.6.13.12.18.25
 3.22.18.1.5.14.9.6.14
 3.25
 3.26
 3.26.32
 3.27.18.8.4.21.6.32.30.7.5
 3.29.19.2.24
 3.29.32.26.8.10.25
 3.3
 3.32.2.29.3.32.28.11.29.30
 3.4.22.19
 3.5
 3.6.24.21.20.32.3.4.26.5
 3.9.11.23.32.26.24.28
 3.9.25.26.7
 30.12.28.2
 30.12.6.30
 30.12.9.25.24.6.7.24.29
 30.15
 30.16.14.9.5.4.10.7.31
 30.16.3.21.10
 30.17.2.25
 30.17.25.3.31.11.3.4.1.10
 30.17.4.5.13.6
 30.18.30.16.29
 30.2.17.8.14
 30.20.3.2.5.15.8.7.17
 30.22.29.21.19.14.3.2.6
 30.23.10.1.10.7.22.28.18.11.17
 30.23.2.13.14.15.29.19.4.12.24
 30.24
 30.24.23.25.32.18.22.12.29.9.22
 30.24.32.15.14.10.11
 30.25
 30.25.17.17.10.29
 30.25.24.22
 30.25.8.24.6.29.31
 30.27.8.6.11.19
 30.3.16.26.7.27.26.9.27.21.18
 30.30.17.5.30.21.19.5.22.22.14
 30.31.13.9
 30.32
 30.4.30.11.13.23.14.24.11
 30.5
 30.6.4
 30.8.18.5.20.6.15
 30.8.9.14.25.30
 30.9.24
 31.13
 31.13.9.1.5.12
 31.17
 31.17.2.30.11
 31.18
 31.18.25.1.14.29.25.5.22.30
 31.18.27.15.20.29.29
 31.18.32.11.7.25.20.5
 31.21.14.20.1.22.2.5.3.27.12
 31.21.22.14.8.21
 31.24.26.18
 31.28.32.4.31.4.7
 31.29.18.26.1.26.17
 31.29.4.29.24.30.30.32.10.23
 31.30.12.20
 31.30.23.7.7.24.32.10.11.1.31
 31.32.12.26.31.32.14.23.28
 31.4.7
 31.5.6.4.8.29.3
 31.7.14.2
 31.9.3.5
 32.1.21.1.16.29.21
 32.1.23.20.14.12.23.5.32.15
 32.1.24.29.22.5.9.24.18.3.13
 32.1.31
 32.15.20.28.5.1.23.4
 32.16
 32.17.8.24.2.14.5.4.22
 32.19.20.24.23.31.8.32.16.29
 32.2.11
 32.24.11.8.12.23.22.19.11.17.18
 32.24.29.6
 32.25.16
 32.25.3.6
 32.27.13.6.7
 32.27.18.7.3.4.2
 32.28.1.32.28.10
 32.29.24.31.25.6.9
 32.3.12.2
 32.3.23.7.2
 32.3.5.9.17.15
 32.30.18.17.1.14.12.18
 32.31.11.22.1
 32.31.26.19.13.29.4.25
 32.4.19
 32.6.13.8.32
 32.6.15.26.14.15.3.19
 32.6.3.2.12.5.28.1.25
 32.6.31.31
 32.6.8
 32.6.9.26.16.4.4.29.7.11
 32.8.29.18.31
 32.8.5
 4.1.24.24.28.24.18
 4.10.28
 4.11.19.17.2.22.20.18.13.32.15
 4.11.22.4.19.24.4.28.6.8.22
 4.13
 4.13.22.11.9.13.27.15.7
 4.14
 4.14.10.19.16
 4.14.16.14.1.8.1.22.17.10
 4.14.17.12.20.17.1.22.3
 4.14.32
 4.15.20.23.12.16.2.16.17
 4.16.22.19.24.21
 4.16.7.25.21.7
 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)

drop index tstidx;
create index tstidx on ltreetest using gist (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
 18.7.3.17.13.5.31.6.31.25.29
 18.9.21.2.31.8.32
 18.9.26.7
 19.10.26.19.5.21.30.23
 19.10.4.30.32.4.12
 19.10.8.10.4.19
 19.11.10.18.14.13.7.7
 19.11.29.13.15.27.12.15.14.12
 19.12.20.24.32.13.11.23.26
 19.12.26.24.29.3
 19.12.30.2.21
 19.15.26.19
 19.16.26.2
 19.16.31.31.29.12
 19.17.12.15
 19.17.13.12.32.16.3
 19.19.25.22.11.6.15.3.2.19
 19.2.26.21.16.11.2.2
 19.2.9.29.6
 19.20.25.7.27.28.27.17.9.3.1
 19.22.21.13.27.13.15
 19.22.29.32.1.21.26.24.23.17
 19.26.24.27.6.24.16.27.32.29
 19.26.32.13.1.12.30.26.22.25
 19.3.12.12
 19.3.23.4.4.21.23
 19.30.18.11.32.14
 19.30.27.26.21.7.18
 19.31.14.25.5.8.21.11.13.20
 19.5.20.3.4.2.3
 19.6.13.14.22.13.9.29
 19.6.24.32.30.13.6.25.8.28
 19.7
 19.7.29.31.3.20.7.21.25.27.29
 19.9.32.23.13.24.1
 2.1.12.19.29.28.3.31.28.28.10
 2.1.3.30.24.17.9
 2.10.10.4.20.1.12.13
 2.10.28.1.17.19.32.28
 2.11.32.25.23
 2.12.14.28.16.21
 2.12.30.22.12
 2.13.9.23.21.2
 2.13.9.28
 2.14.10.4.17.17.8.4.27.20
 2.14.12.13
 2.15.14.20.30.26
 2.15.18.21.5.21.4.7.30
 2.16.3.7.22.18.29.20
 2.19.4.1.15.7.8.9.17.29
 2.2.18.18.3.3.18.8.10.8
 2.22.19
 2.24.4.5.24.32
 2.24.5.3.4.10.27.26.17.28.16
 2.27.15.14
 2.28.5.17.6.32
 2.30.26.10.14.31.18.2
 2.31.25
 2.32.10.13.12
 2.32.8.28.24.20.9.24.25.8.9
 2.4.25.32.16.22.26.13.17.18
 2.6.15.26.23.26.24
 2.8.13.12.17.23.16.7.11.23
 2.9
 20.1.24.3.30.31
 20.13
 20.14.11.2.10.14
 20.15
 20.17.14.7
 20.17.18.21.1
 20.18.24.14.12.13.9
 20.20.32.29.24.5.5.26.22.32
 20.20.7
 20.22.10
 20.23.29.5.7.30.13.14.22
 20.23.7.11.11.31.18.16.3
 20.24.14.15.4.21.12.27.4.12
 20.25.22.19.22
 20.28.22.7.10.28.27.22.14.16
 20.29.18.16.2.21.23.11
 20.3.1.8.8.30.20
 20.30.17
 20.30.28.15.17
 20.30.9.9.14.12.29
 20.31.13.12.19.2.26.16.16.22.28
 20.32.5.1.3.20.3.30.27
 20.32.9
 20.4.1.16.31.3
 20.4.27.31.1
 20.5.4.9.31.14.26.6
 20.6.26.3.30
 20.6.3.26.7.29.28.4
 20.8.19.14.16.7
 20.9.29.32.13.7.23
 21.1.4.9.9.31.24.21.3.29
 21.10.20.9.3.16.9.10.20
 21.14
 21.14.13
 21.14.22.29
 21.14.25.20.13.31.14.20
 21.15.18.18.30.3.20
 21.15.31.24.29.24.26.12.20
 21.17.18.32.7.8
 21.17.27.23.15
 21.17.31.10.31.13.9.26.6.14
 21.18
 21.18.2.1
 21.18.30.19.24.24
 21.20.24.25.6.26.23
 21.20.28.19.27.9
 21.21.10.27
 21.22.31.24.27
 21.23.13
 21.23.17.8.23.11.8.1
 21.28.17.22.10.27.4.20.2.32
 21.28.24.23.3.11.7.12.22.32
 21.30.19.6.28.1.32.2.14.14
 21.31.31.25.5.30.26
 21.32.13.21
 21.32.13.22.3.13.31.23.14.12.9
 21.4.11.18
 21.4.22.20.24.28.6
 21.5.11.18
 21.5.17.19.15.25.18.21.24.9
 21.6.22.28.12.23.11.22
 21.7.23.9.16.5.18.14
 21.7.7.11
 21.8.9
 21.9.27.22.32
 21.9.32.1.27
 22.10.12.23.9
 22.10.16.8
 22.10.18
 22.10.27.19.29.20.29.3.12.14.25
 22.11
 22.12.22.28
 22.13.22.21.25.17.8
 22.13.22.8.30.32.10.24
 22.15
 22.16
 22.16.25.18.25.7.24.29.14.8
 22.17.24.14.21.15.12.18.17.25.11
 22.17.30
 22.17.4.2.22.17
 22.17.7.30.13.24
 22.17.9.11.25.15.3.9
 22.18.20.23.15.9.12
 22.19.20.5.2.20
 22.19.21.11.6.8.29.24
 22.19.5.22.20.31.23.24.14.24.4
 22.20.30
 22.21.32.15.8.29.5.12.10.29
 22.22.10.30.5.15.25.21.19.11
 22.22.27.6.27.15.5.18.21.28.9
 22.23.18.18.9.8.23.7.23.23.16
 22.23.22.30
 22.23.25.28.5.27.9.9.24.31.10
 22.24.22.25.15.23.13
 22.25.4.28.9.20.12.13
 22.26.1.28.9.9.31
 22.26.32
 22.28.20.6.32.32
 22.29.18.32.13.12.22.31.17.22
 22.29.29.11
 22.3.6
 22.30
 22.30.31.24.23.22.5.20.28.1
 22.31.2.32.32.11.26.23.19
 22.31.21.13.13.26.11.5.19
 22.32.6.6.3.8.24.6.25.29
 22.8.20.1.10.28.6.27
 22.9.15.19.12
 23.1.23.18.12.29
 23.10.13.32.14.20.16.11.14
 23.10.5.26.12.4.20.4
 23.12.1.5.32.25.8.24.1.25
 23.12.11.11.15.16.22.31.32.5.8
 23.12.19.25.16.23.22.6.29.4
 23.12.32.22.19.1.22.4
 23.14.12.30.18.4.16.18.7.7
 23.14.30.27.28.26.26.23.8.32
 23.17.22.1.23.4.29.32.4.1
 23.17.25.4.1.16.29.10
 23.17.28.31.28
 23.17.32.15.23.16.25
 23.19.17.31.29.13.1.12.5.25
 23.2.22.7.32.3.27.6
 23.20.12.16.15.2
 23.20.24
 23.20.8
 23.22.10.1.14.24
 23.22.23.14.31.32
 23.23
 23.24.11.31.10.31.18.28.13.18.6
 23.24.16.32.13.29
 23.25.23.11.7.23
 23.27.27.16
 23.27.6.26.22
 23.28.1
 23.28.20.25.30.24.15
 23.28.3.30.15.31.32.3.21.9.19
 23.3.20.24
 23.3.32.21.5.14.10.17.1
 23.31.27.16.8.30.20.27
 23.32.5.25.19.9.15.17.15.11
 23.5.5.17
 23.5.7.12.11.23.10
 23.6.27
 23.8.13.22.21
 24.1.10.20.28.18.6.27.20.30.26
 24.1.29.32.14.15.32.6.15.22
 24.10.10.31.4.29.9
 24.10.8.25.16
 24.11.5
 24.12
 24.13.1.8
 24.15.15.17.22
 24.16.27.10.9
 24.17.24
 24.17.31.20.12.9.19.29.18
 24.18.16
 24.2.26.24.14.15.31.23.17.26
 24.2.6.7.16.7.28
 24.20.23
 24.21.14.25.11.3.20.6.6.16
 24.23.24.4.15.25.17
 24.23.29.8.24.11.21.10.28.14.27
 24.24
 24.25.7.27.30.8.26.17
 24.27.14
 24.27.18.32.14.9.11.28.9
 24.28.13.26.8.8.31
 24.28.32.21
 24.3.23.25
 24.31
 24.31.2.13.5.23.18.16
 24.31.8
 24.32.17.23.24.19.23.9.20.18
 24.32.27
 24.9
 24.9.15.1.14.29.6.4
 24.9.27.16.20.21
 24.9.8.12.29
 25.10
 25.10.29.3.6.21.3.31.13
 25.10.4.28.3.31.19
 25.11.24
 25.14.5.32.25
 25.15.11
 25.16.9.6
 25.17.18.17.27
 25.17.18.30
 25.17.2.20.20.3.29.21.3.12
 25.17.9.16.17.31.23.29.24
 25.18.8.3.23.23.5.9.6
 25.19.27.2.9.20
 25.2.11.20.8.6.22
 25.2.3.15.11.19.5.28.25.14
 25.21.8.17
 25.22.2.25.6
 25.24.2.32.14.18.16
 25.24.29
 25.28.3
 25.28.30.24
 25.29
 25.3
 25.30.1.4.24.11
 25.31
 25.32.24.24.28.15.16.10
 25.4.32
 25.4.4.1.13.32.26.20.20.3
 25.5.30.7.16.12.21.12.11.16
 25.6
 25.6.12.16.1
 25.7.3.21.31.12.28
 25.9
 25.9.1.5.9.11.25.4.11.27.32
 25.9.10
 26.11
 26.12.27.2
 26.13.4.7.13.11.3
 26.14
 26.14.5.32.10
 26.16.12
 26.16.12.3.27.9.28
 26.17.9.13.4.25.32.2.24.9
 26.18
 26.18.32.20
 26.19.3.14.8.28.31.10
 26.24
 26.24.9.12.11.15.31.2
 26.25.10.10.13
 26.25.24
 26.26.22.21.14.11.29.19.14.24
 26.28.14
 26.31.11.23.3
 26.31.16.18.22.13.32.23.9.20
 26.31.6.8.29.8.24
 26.31.7
 26.32.21.31.27.12
 26.32.8.12.30.19.24.8.6.1.10
 26.5.29.7.28
 26.7.22.3.18.21.11
 26.7.5.8.11.9.22.1.6
 26.8.28
 26.9.17.1.18.19.1.11.18.29.3
 26.9.20.12.22.22.32
 27.1.11.3.25.9.6.6
 27.11.14.17.24
 27.11.15.9.24.31.18.4.1.30.20
 27.12.4.2.29.22.15
 27.15.15.15
 27.16
 27.17.15.7.28.20
 27.17.17.19.24.9.14.20
 27.17.3.18.2.13.18
 27.18
 27.18.10.4.22
 27.19.20.1.31.29.5.22.26.3
 27.2.10.4.25.14.2.15.4
 27.21.27.5.13.30.17
 27.21.28.24.7.2.24.23.8
 27.22.11.13.21.25.5.1.27.21.27
 27.23.2.32.11.21
 27.23.20.30.7
 27.24.11.31.21.6.29.17.24.18
 27.25
 27.26.29
 27.27
 27.27.25.10.31.10.21.22.21.16.12
 27.27.30.11.15.24.9.7.4.30
 27.29.1.5.30.6.22.16.23.2.28
 27.3
 27.3.3.11.21.4.25
 27.30.12.11.20.15.11.13
 27.31.2.16.29.6
 27.32.26.21.31.17.32.32
 27.4
 27.4.15.14.19.6.12
 27.4.17.17.32.8.16.15.17.13
 27.5.15.1.15.16.21
 27.5.22
 27.6.13.24.21.27.28.22.3.7.4
 28.1.3
 28.11.11.30.20.11.32
 28.11.27.21.14.16
 28.14.24.26.6.15.16.32.25.13.8
 28.14.32.29.2.3.4
 28.15.18.27
 28.15.25.7.13.6.19.2
 28.17.26.9
 28.18.6.22.13.8.25
 28.2.27.1.20
 28.20.8.9.9.28.30.29
 28.23.2.30.3.8.1.15.15.14.13
 28.25.10.25.19.15
 28.25.11.22
 28.25.29.4.13.5.6
 28.26.25.7
 28.26.26.6.31
 28.26.4.22.13.20.32.27.15
 28.27.24.14
 28.28
 28.30.24.16.17.28.2.13.10
 28.31.10.28.22.26.16.15
 28.4
 28.5.12.9.2.27.11.11.2
 28.5.13
 28.6
 28.6.11.6.15.22.12.6
 28.6.8.22.25
 28.8.21.15.16.28.4.16.26.8
 28.9.3.16.17.21.23.30
 29.1
 29.1.2.14.14
 29.1.7.26.25.11.22
 29.10.12.17.12.16
 29.10.17.11.28.12.18.5.19.15.21
 29.11.20.22.27
 29.14.12.9.17.5.32
 29.14.31.25.7.32.23
 29.15.29.8.31.26.1
 29.20.1.11.21.16.1.2.14.28
 29.23.1.21.31.8
 29.23.15.25.1.6.6.10
 29.25.29.16.32.11.15.25.5.22.3
 29.25.30.15.21.3.25.26.26
 29.26.25.14.24.18.2.13.23.29
 29.27
 29.27.13.29.10.2
 29.27.13.9.28.29.19.13.29.31.27
 29.27.5.22.26
 29.27.7.7.3.11.14.26.21.11
 29.28.9.15.8.27.31
 29.29.17.31
 29.29.18
 29.3.15.17.12.29
 29.3.17.17.18.32
 29.30.21.8.16.23.32
 29.30.7.31.22
 29.32.13.4.1.16.20
 29.5.18.27.3.21.18.6.14
 29.5.32.20.11.7.13.24.17
 29.6.12.31.20.23.32.20
 29.9.25.27.15.16.32.26.6.32
 3.1.13.22.24.14.12.31.3.4
 3.1.14.8.9.16.30.22.20
 3.10
 3.10.27.4.5.6.19.12.28.12
 3.10.4.5.28.11
 3.11.18.21.5.20.30
 3.11.32.11.22.3.7.17.8.13.23
 3.13
 3.14.1.14.17.28.29.16
 3.14.11.15.21.32.2.15.13
 3.14.30.5.32.22.29
 3.15.2.23.22.2.16.14
 3.18
 3.18.18
 3.18.8.22.7.28.32.31.3
 3.19.11.6.5
 3.20.16.13.29.20
 3.20.19.10.17.27.3.6.22.23
 3.21.16.24.23.12.16.32.3
 3.21.6.13.12.18.25
 3.22.18.1.5.14.9.6.14
 3.25
 3.26
 3.26.32
 3.27.18.8.4.21.6.32.30.7.5
 3.29.19.2.24
 3.29.32.26.8.10.25
 3.3
 3.32.2.29.3.32.28.11.29.30
 3.4.22.19
 3.5
 3.6.24.21.20.32.3.4.26.5
 3.9.11.23.32.26.24.28
 3.9.25.26.7
 30.12.28.2
 30.12.6.30
 30.12.9.25.24.6.7.24.29
 30.15
 30.16.14.9.5.4.10.7.31
 30.16.3.21.10
 30.17.2.25
 30.17.25.3.31.11.3.4.1.10
 30.17.4.5.13.6
 30.18.30.16.29
 30.2.17.8.14
 30.20.3.2.5.15.8.7.17
 30.22.29.21.19.14.3.2.6
 30.23.10.1.10.7.22.28.18.11.17
 30.23.2.13.14.15.29.19.4.12.24
 30.24
 30.24.23.25.32.18.22.12.29.9.22
 30.24.32.15.14.10.11
 30.25
 30.25.17.17.10.29
 30.25.24.22
 30.25.8.24.6.29.31
 30.27.8.6.11.19
 30.3.16.26.7.27.26.9.27.21.18
 30.30.17.5.30.21.19.5.22.22.14
 30.31.13.9
 30.32
 30.4.30.11.13.23.14.24.11
 30.5
 30.6.4
 30.8.18.5.20.6.15
 30.8.9.14.25.30
 30.9.24
 31.13
 31.13.9.1.5.12
 31.17
 31.17.2.30.11
 31.18
 31.18.25.1.14.29.25.5.22.30
 31.18.27.15.20.29.29
 31.18.32.11.7.25.20.5
 31.21.14.20.1.22.2.5.3.27.12
 31.21.22.14.8.21
 31.24.26.18
 31.28.32.4.31.4.7
 31.29.18.26.1.26.17
 31.29.4.29.24.30.30.32.10.23
 31.30.12.20
 31.30.23.7.7.24.32.10.11.1.31
 31.32.12.26.31.32.14.23.28
 31.4.7
 31.5.6.4.8.29.3
 31.7.14.2
 31.9.3.5
 32.1.21.1.16.29.21
 32.1.23.20.14.12.23.5.32.15
 32.1.24.29.22.5.9.24.18.3.13
 32.1.31
 32.15.20.28.5.1.23.4
 32.16
 32.17.8.24.2.14.5.4.22
 32.19.20.24.23.31.8.32.16.29
 32.2.11
 32.24.11.8.12.23.22.19.11.17.18
 32.24.29.6
 32.25.16
 32.25.3.6
 32.27.13.6.7
 32.27.18.7.3.4.2
 32.28.1.32.28.10
 32.29.24.31.25.6.9
 32.3.12.2
 32.3.23.7.2
 32.3.5.9.17.15
 32.30.18.17.1.14.12.18
 32.31.11.22.1
 32.31.26.19.13.29.4.25
 32.4.19
 32.6.13.8.32
 32.6.15.26.14.15.3.19
 32.6.3.2.12.5.28.1.25
 32.6.31.31
 32.6.8
 32.6.9.26.16.4.4.29.7.11
 32.8.29.18.31
 32.8.5
 4.1.24.24.28.24.18
 4.10.28
 4.11.19.17.2.22.20.18.13.32.15
 4.11.22.4.19.24.4.28.6.8.22
 4.13
 4.13.22.11.9.13.27.15.7
 4.14
 4.14.10.19.16
 4.14.16.14.1.8.1.22.17.10
 4.14.17.12.20.17.1.22.3
 4.14.32
 4.15.20.23.12.16.2.16.17
 4.16.22.19.24.21
 4.16.7.25.21.7
 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
(883 rows)

SELECT * FROM ltreetest WHERE t >  '12.3' order by t asc;
                t                 
----------------------------------
 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
 18.7.3.17.13.5.31.6.31.25.29
 18.9.21.2.31.8.32
 18.9.26.7
 19.10.26.19.5.21.30.23
 19.10.4.30.32.4.12
 19.10.8.10.4.19
 19.11.10.18.14.13.7.7
 19.11.29.13.15.27.12.15.14.12
 19.12.20.24.32.13.11.23.26
 19.12.26.24.29.3
 19.12.30.2.21
 19.15.26.19
 19.16.26.2
 19.16.31.31.29.12
 19.17.12.15
 19.17.13.12.32.16.3
 19.19.25.22.11.6.15.3.2.19
 19.2.26.21.16.11.2.2
 19.2.9.29.6
 19.20.25.7.27.28.27.17.9.3.1
 19.22.21.13.27.13.15
 19.22.29.32.1.21.26.24.23.17
 19.26.24.27.6.24.16.27.32.29
 19.26.32.13.1.12.30.26.22.25
 19.3.12.12
 19.3.23.4.4.21.23
 19.30.18.11.32.14
 19.30.27.26.21.7.18
 19.31.14.25.5.8.21.11.13.20
 19.5.20.3.4.2.3
 19.6.13.14.22.13.9.29
 19.6.24.32.30.13.6.25.8.28
 19.7
 19.7.29.31.3.20.7.21.25.27.29
 19.9.32.23.13.24.1
 2.1.12.19.29.28.3.31.28.28.10
 2.1.3.30.24.17.9
 2.10.10.4.20.1.12.13
 2.10.28.1.17.19.32.28
 2.11.32.25.23
 2.12.14.28.16.21
 2.12.30.22.12
 2.13.9.23.21.2
 2.13.9.28
 2.14.10.4.17.17.8.4.27.20
 2.14.12.13
 2.15.14.20.30.26
 2.15.18.21.5.21.4.7.30
 2.16.3.7.22.18.29.20
 2.19.4.1.15.7.8.9.17.29
 2.2.18.18.3.3.18.8.10.8
 2.22.19
 2.24.4.5.24.32
 2.24.5.3.4.10.27.26.17.28.16
 2.27.15.14
 2.28.5.17.6.32
 2.30.26.10.14.31.18.2
 2.31.25
 2.32.10.13.12
 2.32.8.28.24.20.9.24.25.8.9
 2.4.25.32.16.22.26.13.17.18
 2.6.15.26.23.26.24
 2.8.13.12.17.23.16.7.11.23
 2.9
 20.1.24.3.30.31
 20.13
 20.14.11.2.10.14
 20.15
 20.17.14.7
 20.17.18.21.1
 20.18.24.14.12.13.9
 20.20.32.29.24.5.5.26.22.32
 20.20.7
 20.22.10
 20.23.29.5.7.30.13.14.22
 20.23.7.11.11.31.18.16.3
 20.24.14.15.4.21.12.27.4.12
 20.25.22.19.22
 20.28.22.7.10.28.27.22.14.16
 20.29.18.16.2.21.23.11
 20.3.1.8.8.30.20
 20.30.17
 20.30.28.15.17
 20.30.9.9.14.12.29
 20.31.13.12.19.2.26.16.16.22.28
 20.32.5.1.3.20.3.30.27
 20.32.9
 20.4.1.16.31.3
 20.4.27.31.1
 20.5.4.9.31.14.26.6
 20.6.26.3.30
 20.6.3.26.7.29.28.4
 20.8.19.14.16.7
 20.9.29.32.13.7.23
 21.1.4.9.9.31.24.21.3.29
 21.10.20.9.3.16.9.10.20
 21.14
 21.14.13
 21.14.22.29
 21.14.25.20.13.31.14.20
 21.15.18.18.30.3.20
 21.15.31.24.29.24.26.12.20
 21.17.18.32.7.8
 21.17.27.23.15
 21.17.31.10.31.13.9.26.6.14
 21.18
 21.18.2.1
 21.18.30.19.24.24
 21.20.24.25.6.26.23
 21.20.28.19.27.9
 21.21.10.27
 21.22.31.24.27
 21.23.13
 21.23.17.8.23.11.8.1
 21.28.17.22.10.27.4.20.2.32
 21.28.24.23.3.11.7.12.22.32
 21.30.19.6.28.1.32.2.14.14
 21.31.31.25.5.30.26
 21.32.13.21
 21.32.13.22.3.13.31.23.14.12.9
 21.4.11.18
 21.4.22.20.24.28.6
 21.5.11.18
 21.5.17.19.15.25.18.21.24.9
 21.6.22.28.12.23.11.22
 21.7.23.9.16.5.18.14
 21.7.7.11
 21.8.9
 21.9.27.22.32
 21.9.32.1.27
 22.10.12.23.9
 22.10.16.8
 22.10.18
 22.10.27.19.29.20.29.3.12.14.25
 22.11
 22.12.22.28
 22.13.22.21.25.17.8
 22.13.22.8.30.32.10.24
 22.15
 22.16
 22.16.25.18.25.7.24.29.14.8
 22.17.24.14.21.15.12.18.17.25.11
 22.17.30
 22.17.4.2.22.17
 22.17.7.30.13.24
 22.17.9.11.25.15.3.9
 22.18.20.23.15.9.12
 22.19.20.5.2.20
 22.19.21.11.6.8.29.24
 22.19.5.22.20.31.23.24.14.24.4
 22.20.30
 22.21.32.15.8.29.5.12.10.29
 22.22.10.30.5.15.25.21.19.11
 22.22.27.6.27.15.5.18.21.28.9
 22.23.18.18.9.8.23.7.23.23.16
 22.23.22.30
 22.23.25.28.5.27.9.9.24.31.10
 22.24.22.25.15.23.13
 22.25.4.28.9.20.12.13
 22.26.1.28.9.9.31
 22.26.32
 22.28.20.6.32.32
 22.29.18.32.13.12.22.31.17.22
 22.29.29.11
 22.3.6
 22.30
 22.30.31.24.23.22.5.20.28.1
 22.31.2.32.32.11.26.23.19
 22.31.21.13.13.26.11.5.19
 22.32.6.6.3.8.24.6.25.29
 22.8.20.1.10.28.6.27
 22.9.15.19.12
 23.1.23.18.12.29
 23.10.13.32.14.20.16.11.14
 23.10.5.26.12.4.20.4
 23.12.1.5.32.25.8.24.1.25
 23.12.11.11.15.16.22.31.32.5.8
 23.12.19.25.16.23.22.6.29.4
 23.12.32.22.19.1.22.4
 23.14.12.30.18.4.16.18.7.7
 23.14.30.27.28.26.26.23.8.32
 23.17.22.1.23.4.29.32.4.1
 23.17.25.4.1.16.29.10
 23.17.28.31.28
 23.17.32.15.23.16.25
 23.19.17.31.29.13.1.12.5.25
 23.2.22.7.32.3.27.6
 23.20.12.16.15.2
 23.20.24
 23.20.8
 23.22.10.1.14.24
 23.22.23.14.31.32
 23.23
 23.24.11.31.10.31.18.28.13.18.6
 23.24.16.32.13.29
 23.25.23.11.7.23
 23.27.27.16
 23.27.6.26.22
 23.28.1
 23.28.20.25.30.24.15
 23.28.3.30.15.31.32.3.21.9.19
 23.3.20.24
 23.3.32.21.5.14.10.17.1
 23.31.27.16.8.30.20.27
 23.32.5.25.19.9.15.17.15.11
 23.5.5.17
 23.5.7.12.11.23.10
 23.6.27
 23.8.13.22.21
 24.1.10.20.28.18.6.27.20.30.26
 24.1.29.32.14.15.32.6.15.22
 24.10.10.31.4.29.9
 24.10.8.25.16
 24.11.5
 24.12
 24.13.1.8
 24.15.15.17.22
 24.16.27.10.9
 24.17.24
 24.17.31.20.12.9.19.29.18
 24.18.16
 24.2.26.24.14.15.31.23.17.26
 24.2.6.7.16.7.28
 24.20.23
 24.21.14.25.11.3.20.6.6.16
 24.23.24.4.15.25.17
 24.23.29.8.24.11.21.10.28.14.27
 24.24
 24.25.7.27.30.8.26.17
 24.27.14
 24.27.18.32.14.9.11.28.9
 24.28.13.26.8.8.31
 24.28.32.21
 24.3.23.25
 24.31
 24.31.2.13.5.23.18.16
 24.31.8
 24.32.17.23.24.19.23.9.20.18
 24.32.27
 24.9
 24.9.15.1.14.29.6.4
 24.9.27.16.20.21
 24.9.8.12.29
 25.10
 25.10.29.3.6.21.3.31.13
 25.10.4.28.3.31.19
 25.11.24
 25.14.5.32.25
 25.15.11
 25.16.9.6
 25.17.18.17.27
 25.17.18.30
 25.17.2.20.20.3.29.21.3.12
 25.17.9.16.17.31.23.29.24
 25.18.8.3.23.23.5.9.6
 25.19.27.2.9.20
 25.2.11.20.8.6.22
 25.2.3.15.11.19.5.28.25.14
 25.21.8.17
 25.22.2.25.6
 25.24.2.32.14.18.16
 25.24.29
 25.28.3
 25.28.30.24
 25.29
 25.3
 25.30.1.4.24.11
 25.31
 25.32.24.24.28.15.16.10
 25.4.32
 25.4.4.1.13.32.26.20.20.3
 25.5.30.7.16.12.21.12.11.16
 25.6
 25.6.12.16.1
 25.7.3.21.31.12.28
 25.9
 25.9.1.5.9.11.25.4.11.27.32
 25.9.10
 26.11
 26.12.27.2
 26.13.4.7.13.11.3
 26.14
 26.14.5.32.10
 26.16.12
 26.16.12.3.27.9.28
 26.17.9.13.4.25.32.2.24.9
 26.18
 26.18.32.20
 26.19.3.14.8.28.31.10
 26.24
 26.24.9.12.11.15.31.2
 26.25.10.10.13
 26.25.24
 26.26.22.21.14.11.29.19.14.24
 26.28.14
 26.31.11.23.3
 26.31.16.18.22.13.32.23.9.20
 26.31.6.8.29.8.24
 26.31.7
 26.32.21.31.27.12
 26.32.8.12.30.19.24.8.6.1.10
 26.5.29.7.28
 26.7.22.3.18.21.11
 26.7.5.8.11.9.22.1.6
 26.8.28
 26.9.17.1.18.19.1.11.18.29.3
 26.9.20.12.22.22.32
 27.1.11.3.25.9.6.6
 27.11.14.17.24
 27.11.15.9.24.31.18.4.1.30.20
 27.12.4.2.29.22.15
 27.15.15.15
 27.16
 27.17.15.7.28.20
 27.17.17.19.24.9.14.20
 27.17.3.18.2.13.18
 27.18
 27.18.10.4.22
 27.19.20.1.31.29.5.22.26.3
 27.2.10.4.25.14.2.15.4
 27.21.27.5.13.30.17
 27.21.28.24.7.2.24.23.8
 27.22.11.13.21.25.5.1.27.21.27
 27.23.2.32.11.21
 27.23.20.30.7
 27.24.11.31.21.6.29.17.24.18
 27.25
 27.26.29
 27.27
 27.27.25.10.31.10.21.22.21.16.12
 27.27.30.11.15.24.9.7.4.30
 27.29.1.5.30.6.22.16.23.2.28
 27.3
 27.3.3.11.21.4.25
 27.30.12.11.20.15.11.13
 27.31.2.16.29.6
 27.32.26.21.31.17.32.32
 27.4
 27.4.15.14.19.6.12
 27.4.17.17.32.8.16.15.17.13
 27.5.15.1.15.16.21
 27.5.22
 27.6.13.24.21.27.28.22.3.7.4
 28.1.3
 28.11.11.30.20.11.32
 28.11.27.21.14.16
 28.14.24.26.6.15.16.32.25.13.8
 28.14.32.29.2.3.4
 28.15.18.27
 28.15.25.7.13.6.19.2
 28.17.26.9
 28.18.6.22.13.8.25
 28.2.27.1.20
 28.20.8.9.9.28.30.29
 28.23.2.30.3.8.1.15.15.14.13
 28.25.10.25.19.15
 28.25.11.22
 28.25.29.4.13.5.6
 28.26.25.7
 28.26.26.6.31
 28.26.4.22.13.20.32.27.15
 28.27.24.14
 28.28
 28.30.24.16.17.28.2.13.10
 28.31.10.28.22.26.16.15
 28.4
 28.5.12.9.2.27.11.11.2
 28.5.13
 28.6
 28.6.11.6.15.22.12.6
 28.6.8.22.25
 28.8.21.15.16.28.4.16.26.8
 28.9.3.16.17.21.23.30
 29.1
 29.1.2.14.14
 29.1.7.26.25.11.22
 29.10.12.17.12.16
 29.10.17.11.28.12.18.5.19.15.21
 29.11.20.22.27
 29.14.12.9.17.5.32
 29.14.31.25.7.32.23
 29.15.29.8.31.26.1
 29.20.1.11.21.16.1.2.14.28
 29.23.1.21.31.8
 29.23.15.25.1.6.6.10
 29.25.29.16.32.11.15.25.5.22.3
 29.25.30.15.21.3.25.26.26
 29.26.25.14.24.18.2.13.23.29
 29.27
 29.27.13.29.10.2
 29.27.13.9.28.29.19.13.29.31.27
 29.27.5.22.26
 29.27.7.7.3.11.14.26.21.11
 29.28.9.15.8.27.31
 29.29.17.31
 29.29.18
 29.3.15.17.12.29
 29.3.17.17.18.32
 29.30.21.8.16.23.32
 29.30.7.31.22
 29.32.13.4.1.16.20
 29.5.18.27.3.21.18.6.14
 29.5.32.20.11.7.13.24.17
 29.6.12.31.20.23.32.20
 29.9.25.27.15.16.32.26.6.32
 3.1.13.22.24.14.12.31.3.4
 3.1.14.8.9.16.30.22.20
 3.10
 3.10.27.4.5.6.19.12.28.12
 3.10.4.5.28.11
 3.11.18.21.5.20.30
 3.11.32.11.22.3.7.17.8.13.23
 3.13
 3.14.1.14.17.28.29.16
 3.14.11.15.21.32.2.15.13
 3.14.30.5.32.22.29
 3.15.2.23.22.2.16.14
 3.18
 3.18.18
 3.18.8.22.7.28.32.31.3
 3.19.11.6.5
 3.20.16.13.29.20
 3.20.19.10.17.27.3.6.22.23
 3.21.16.24.23.12.16.32.3
 3.21.6.13.12.18.25
 3.22.18.1.5.14.9.6.14
 3.25
 3.26
 3.26.32
 3.27.18.8.4.21.6.32.30.7.5
 3.29.19.2.24
 3.29.32.26.8.10.25
 3.3
 3.32.2.29.3.32.28.11.29.30
 3.4.22.19
 3.5
 3.6.24.21.20.32.3.4.26.5
 3.9.11.23.32.26.24.28
 3.9.25.26.7
 30.12.28.2
 30.12.6.30
 30.12.9.25.24.6.7.24.29
 30.15
 30.16.14.9.5.4.10.7.31
 30.16.3.21.10
 30.17.2.25
 30.17.25.3.31.11.3.4.1.10
 30.17.4.5.13.6
 30.18.30.16.29
 30.2.17.8.14
 30.20.3.2.5.15.8.7.17
 30.22.29.21.19.14.3.2.6
 30.23.10.1.10.7.22.28.18.11.17
 30.23.2.13.14.15.29.19.4.12.24
 30.24
 30.24.23.25.32.18.22.12.29.9.22
 30.24.32.15.14.10.11
 30.25
 30.25.17.17.10.29
 30.25.24.22
 30.25.8.24.6.29.31
 30.27.8.6.11.19
 30.3.16.26.7.27.26.9.27.21.18
 30.30.17.5.30.21.19.5.22.22.14
 30.31.13.9
 30.32
 30.4.30.11.13.23.14.24.11
 30.5
 30.6.4
 30.8.18.5.20.6.15
 30.8.9.14.25.30
 30.9.24
 31.13
 31.13.9.1.5.12
 31.17
 31.17.2.30.11
 31.18
 31.18.25.1.14.29.25.5.22.30
 31.18.27.15.20.29.29
 31.18.32.11.7.25.20.5
 31.21.14.20.1.22.2.5.3.27.12
 31.21.22.14.8.21
 31.24.26.18
 31.28.32.4.31.4.7
 31.29.18.26.1.26.17
 31.29.4.29.24.30.30.32.10.23
 31.30.12.20
 31.30.23.7.7.24.32.10.11.1.31
 31.32.12.26.31.32.14.23.28
 31.4.7
 31.5.6.4.8.29.3
 31.7.14.2
 31.9.3.5
 32.1.21.1.16.29.21
 32.1.23.20.14.12.23.5.32.15
 32.1.24.29.22.5.9.24.18.3.13
 32.1.31
 32.15.20.28.5.1.23.4
 32.16
 32.17.8.24.2.14.5.4.22
 32.19.20.24.23.31.8.32.16.29
 32.2.11
 32.24.11.8.12.23.22.19.11.17.18
 32.24.29.6
 32.25.16
 32.25.3.6
 32.27.13.6.7
 32.27.18.7.3.4.2
 32.28.1.32.28.10
 32.29.24.31.25.6.9
 32.3.12.2
 32.3.23.7.2
 32.3.5.9.17.15
 32.30.18.17.1.14.12.18
 32.31.11.22.1
 32.31.26.19.13.29.4.25
 32.4.19
 32.6.13.8.32
 32.6.15.26.14.15.3.19
 32.6.3.2.12.5.28.1.25
 32.6.31.31
 32.6.8
 32.6.9.26.16.4.4.29.7.11
 32.8.29.18.31
 32.8.5
 4.1.24.24.28.24.18
 4.10.28
 4.11.19.17.2.22.20.18.13.32.15
 4.11.22.4.19.24.4.28.6.8.22
 4.13
 4.13.22.11.9.13.27.15.7
 4.14
 4.14.10.19.16
 4.14.16.14.1.8.1.22.17.10
 4.14.17.12.20.17.1.22.3
 4.14.32
 4.15.20.23.12.16.2.16.17
 4.16.22.19.24.21
 4.16.7.25.21.7
 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 table _ltreetest (t ltree[]);
\copy _ltreetest FROM 'data/_ltree.data'
SELECT count(*) FROM _ltreetest WHERE t @> '1.1.1' ;
 count 
-------
    15
(1 row)

SELECT count(*) FROM _ltreetest WHERE t <@ '1.1.1' ;
 count 
-------
    19
(1 row)

SELECT count(*) FROM _ltreetest WHERE t @ '23 & 1' ;
 count 
-------
   147
(1 row)

SELECT count(*) FROM _ltreetest WHERE t ~ '1.1.1.*' ;
 count 
-------
    19
(1 row)

SELECT count(*) FROM _ltreetest WHERE t ~ '*.1' ;
 count 
-------
   109
(1 row)

SELECT count(*) FROM _ltreetest WHERE t ~ '23.*{1}.1' ;
 count 
-------
     5
(1 row)

SELECT count(*) FROM _ltreetest WHERE t ~ '23.*.1' ;
 count 
-------
    11
(1 row)

SELECT count(*) FROM _ltreetest WHERE t ~ '23.*.2' ;
 count 
-------
     5
(1 row)

SELECT count(*) FROM _ltreetest WHERE t ? '{23.*.1,23.*.2}' ;
 count 
-------
    15
(1 row)

create index _tstidx on _ltreetest using gist (t);
set enable_seqscan=off;
SELECT count(*) FROM _ltreetest WHERE t @> '1.1.1' ;
 count 
-------
    15
(1 row)

SELECT count(*) FROM _ltreetest WHERE t <@ '1.1.1' ;
 count 
-------
    19
(1 row)

SELECT count(*) FROM _ltreetest WHERE t @ '23 & 1' ;
 count 
-------
   147
(1 row)

SELECT count(*) FROM _ltreetest WHERE t ~ '1.1.1.*' ;
 count 
-------
    19
(1 row)

SELECT count(*) FROM _ltreetest WHERE t ~ '*.1' ;
 count 
-------
   109
(1 row)

SELECT count(*) FROM _ltreetest WHERE t ~ '23.*{1}.1' ;
 count 
-------
     5
(1 row)

SELECT count(*) FROM _ltreetest WHERE t ~ '23.*.1' ;
 count 
-------
    11
(1 row)

SELECT count(*) FROM _ltreetest WHERE t ~ '23.*.2' ;
 count 
-------
     5
(1 row)

SELECT count(*) FROM _ltreetest WHERE t ? '{23.*.1,23.*.2}' ;
 count 
-------
    15
(1 row)