tsearch.out

PostgreSQL7.4.6 for Linux

--
-- first, define the datatype.  Turn off echoing so that expected file
-- does not depend on contents of seg.sql.
--
\set ECHO none
psql:tsearch.sql:9: NOTICE:  type "txtidx" is not yet defined
DETAIL:  Creating a shell type definition.
psql:tsearch.sql:14: NOTICE:  argument type txtidx is only a shell
psql:tsearch.sql:38: NOTICE:  type "query_txt" is not yet defined
DETAIL:  Creating a shell type definition.
psql:tsearch.sql:43: NOTICE:  argument type query_txt is only a shell
psql:tsearch.sql:55: NOTICE:  type "mquery_txt" is not yet defined
DETAIL:  Creating a shell type definition.
psql:tsearch.sql:61: NOTICE:  argument type mquery_txt is only a shell
psql:tsearch.sql:156: NOTICE:  type "gtxtidx" is not yet defined
DETAIL:  Creating a shell type definition.
psql:tsearch.sql:161: NOTICE:  argument type gtxtidx is only a shell
--txtidx
SELECT '1'::txtidx;
 txtidx 
--------
 '1'
(1 row)

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

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

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

SELECT '1 2'::txtidx;
 txtidx  
---------
 '1' '2'
(1 row)

SELECT '\'1 2\''::txtidx;
 txtidx 
--------
 '1 2'
(1 row)

SELECT '\'1 \\\'2\''::txtidx;
 txtidx  
---------
 '1 \'2'
(1 row)

SELECT '\'1 \\\'2\'3'::txtidx;
   txtidx    
-------------
 '3' '1 \'2'
(1 row)

SELECT '\'1 \\\'2\' 3'::txtidx;
   txtidx    
-------------
 '3' '1 \'2'
(1 row)

SELECT '\'1 \\\'2\' \' 3\' 4 '::txtidx;
      txtidx      
------------------
 '4' ' 3' '1 \'2'
(1 row)

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

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

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

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

SELECT '\'1 2\''::query_txt;
 query_txt 
-----------
 '1 2'
(1 row)

SELECT '\'1 \\\'2\''::query_txt;
 query_txt 
-----------
 '1 \'2'
(1 row)

SELECT '!1'::query_txt;
 query_txt 
-----------
 !'1'
(1 row)

SELECT '1|2'::query_txt;
 query_txt 
-----------
 '1' | '2'
(1 row)

SELECT '1|!2'::query_txt;
 query_txt  
------------
 '1' | !'2'
(1 row)

SELECT '!1|2'::query_txt;
 query_txt  
------------
 !'1' | '2'
(1 row)

SELECT '!1|!2'::query_txt;
  query_txt  
-------------
 !'1' | !'2'
(1 row)

SELECT '!(!1|!2)'::query_txt;
    query_txt     
------------------
 !( !'1' | !'2' )
(1 row)

SELECT '!(!1|2)'::query_txt;
    query_txt    
-----------------
 !( !'1' | '2' )
(1 row)

SELECT '!(1|!2)'::query_txt;
    query_txt    
-----------------
 !( '1' | !'2' )
(1 row)

SELECT '!(1|2)'::query_txt;
   query_txt    
----------------
 !( '1' | '2' )
(1 row)

SELECT '1&2'::query_txt;
 query_txt 
-----------
 '1' & '2'
(1 row)

SELECT '!1&2'::query_txt;
 query_txt  
------------
 !'1' & '2'
(1 row)

SELECT '1&!2'::query_txt;
 query_txt  
------------
 '1' & !'2'
(1 row)

SELECT '!1&!2'::query_txt;
  query_txt  
-------------
 !'1' & !'2'
(1 row)

SELECT '(1&2)'::query_txt;
 query_txt 
-----------
 '1' & '2'
(1 row)

SELECT '1&(2)'::query_txt;
 query_txt 
-----------
 '1' & '2'
(1 row)

SELECT '!(1)&2'::query_txt;
 query_txt  
------------
 !'1' & '2'
(1 row)

SELECT '!(1&2)'::query_txt;
   query_txt    
----------------
 !( '1' & '2' )
(1 row)

SELECT '1|2&3'::query_txt;
    query_txt    
-----------------
 '1' | '2' & '3'
(1 row)

SELECT '1|(2&3)'::query_txt;
    query_txt    
-----------------
 '1' | '2' & '3'
(1 row)

SELECT '(1|2)&3'::query_txt;
      query_txt      
---------------------
 ( '1' | '2' ) & '3'
(1 row)

SELECT '1|2&!3'::query_txt;
    query_txt     
------------------
 '1' | '2' & !'3'
(1 row)

SELECT '1|!2&3'::query_txt;
    query_txt     
------------------
 '1' | !'2' & '3'
(1 row)

SELECT '!1|2&3'::query_txt;
    query_txt     
------------------
 !'1' | '2' & '3'
(1 row)

SELECT '!1|(2&3)'::query_txt;
    query_txt     
------------------
 !'1' | '2' & '3'
(1 row)

SELECT '!(1|2)&3'::query_txt;
      query_txt       
----------------------
 !( '1' | '2' ) & '3'
(1 row)

SELECT '(!1|2)&3'::query_txt;
      query_txt       
----------------------
 ( !'1' | '2' ) & '3'
(1 row)

SELECT '1|(2|(4|(5|6)))'::query_txt;
                query_txt                
-----------------------------------------
 '1' | ( '2' | ( '4' | ( '5' | '6' ) ) )
(1 row)

SELECT '1|2|4|5|6'::query_txt;
                query_txt                
-----------------------------------------
 ( ( ( '1' | '2' ) | '4' ) | '5' ) | '6'
(1 row)

SELECT '1&(2&(4&(5&6)))'::query_txt;
          query_txt          
-----------------------------
 '1' & '2' & '4' & '5' & '6'
(1 row)

SELECT '1&2&4&5&6'::query_txt;
          query_txt          
-----------------------------
 '1' & '2' & '4' & '5' & '6'
(1 row)

SELECT '1&(2&(4&(5|6)))'::query_txt;
            query_txt            
---------------------------------
 '1' & '2' & '4' & ( '5' | '6' )
(1 row)

SELECT '1&(2&(4&(5|!6)))'::query_txt;
            query_txt             
----------------------------------
 '1' & '2' & '4' & ( '5' | !'6' )
(1 row)

SELECT '1&(\'2\'&(\' 4\'&(\\|5 | \'6 \\\' !|&\')))'::query_txt;
                query_txt                 
------------------------------------------
 '1' & '2' & ' 4' & ( '|5' | '6 \' !|&' )
(1 row)

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

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

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

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

SELECT '\'1 2\''::mquery_txt;
 mquery_txt 
------------
 '1' & '2'
(1 row)

SELECT '\'1 \\\'2\''::mquery_txt;
 mquery_txt 
------------
 '1' & '2'
(1 row)

SELECT '!1'::mquery_txt;
 mquery_txt 
------------
 !'1'
(1 row)

SELECT '1|2'::mquery_txt;
 mquery_txt 
------------
 '1' | '2'
(1 row)

SELECT '1|!2'::mquery_txt;
 mquery_txt 
------------
 '1' | !'2'
(1 row)

SELECT '!1|2'::mquery_txt;
 mquery_txt 
------------
 !'1' | '2'
(1 row)

SELECT '!1|!2'::mquery_txt;
 mquery_txt  
-------------
 !'1' | !'2'