tsearch2.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:tsearch2.sql:13: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "pg_ts_dict_pkey" for table "pg_ts_dict"
psql:tsearch2.sql:145: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "pg_ts_parser_pkey" for table "pg_ts_parser"
psql:tsearch2.sql:244: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "pg_ts_cfg_pkey" for table "pg_ts_cfg"
psql:tsearch2.sql:251: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "pg_ts_cfgmap_pkey" for table "pg_ts_cfgmap"
psql:tsearch2.sql:339: NOTICE:  type "tsvector" is not yet defined
DETAIL:  Creating a shell type definition.
psql:tsearch2.sql:344: NOTICE:  argument type tsvector is only a shell
psql:tsearch2.sql:398: NOTICE:  type "tsquery" is not yet defined
DETAIL:  Creating a shell type definition.
psql:tsearch2.sql:403: NOTICE:  argument type tsquery is only a shell
psql:tsearch2.sql:545: NOTICE:  type "gtsvector" is not yet defined
DETAIL:  Creating a shell type definition.
psql:tsearch2.sql:550: NOTICE:  argument type gtsvector is only a shell
--tsvector
SELECT '1'::tsvector;
 tsvector 
----------
 '1'
(1 row)

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

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

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

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

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

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

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

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

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

select '\'w\':4A,3B,2C,1D,5 a:8';
       ?column?        
-----------------------
 'w':4A,3B,2C,1D,5 a:8
(1 row)

select 'a:3A b:2a'::tsvector || 'ba:1234 a:1B';
          ?column?          
----------------------------
 'a':3A,4B 'b':2A 'ba':1237
(1 row)

select setweight('w:12B w:13* w:12,5,6 a:1,3* a:3 w asd:1dc asd zxc:81,567,222A'::tsvector, 'c');
                        setweight                         
----------------------------------------------------------
 'a':1C,3C 'w':5C,6C,12C,13C 'asd':1C 'zxc':81C,222C,567C
(1 row)

select strip('w:12B w:13* w:12,5,6 a:1,3* a:3 w asd:1dc asd'::tsvector);
     strip     
---------------
 'a' 'w' 'asd'
(1 row)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT '\'the wether\':dc & \' sKies \':BC & a:d b:a';
                 ?column?                 
------------------------------------------
 'the wether':dc & ' sKies ':BC & a:d b:a
(1 row)

select lexize('simple', 'ASD56 hsdkf');
     lexize      
-----------------
 {"asd56 hsdkf"}
(1 row)

select lexize('en_stem', 'SKIES Problems identity');
          lexize          
--------------------------
 {"skies problems ident"}
(1 row)

select * from token_type('default');
 tokid |    alias     |               descr               
-------+--------------+-----------------------------------
     1 | lword        | Latin word
     2 | nlword       | Non-latin word
     3 | word         | Word
     4 | email        | Email
     5 | url          | URL
     6 | host         | Host
     7 | sfloat       | Scientific notation
     8 | version      | VERSION
     9 | part_hword   | Part of hyphenated word
    10 | nlpart_hword | Non-latin part of hyphenated word
    11 | lpart_hword  | Latin part of hyphenated word
    12 | blank        | Space symbols
    13 | tag          | HTML Tag
    14 | http         | HTTP head
    15 | hword        | Hyphenated word
    16 | lhword       | Latin hyphenated word
    17 | nlhword      | Non-latin hyphenated word
    18 | uri          | URI
    19 | file         | File or path name
    20 | float        | Decimal notation
    21 | int          | Signed integer
    22 | uint         | Unsigned integer
    23 | entity       | HTML Entity
(23 rows)

select * from parse('default', '345 qwe@efd.r \' http://www.com/ http://aew.werc.ewr/?ad=qwe&dw 1aew.werc.ewr/?ad=qwe&dw 2aew.werc.ewr http://3aew.werc.ewr/?ad=qwe&dw http://4aew.werc.ewr http://5aew.werc.ewr:8100/?  ad=qwe&dw 6aew.werc.ewr:8100/?ad=qwe&dw 7aew.werc.ewr:8100/?ad=qwe&dw=%20%32 +4.0e-10 qwe qwe qwqwe 234.435 455 5.005 [e-mail] qwe-wer asdf <fr>qwer jf sdjk<we hjwer <werrwe> ewr1> ewri2 <a href="qwe<qwe>">
/usr/local/fff /awdf/dwqe/4325 rewt/ewr wefjn /wqe-324/ewr gist.h gist.h.c gist.c. readline 4.2 4.2. 4.2, readline-4.2 readline-4.2. 234 
<i <b> wow  < jqw <> qwerty');
 tokid |                token                 
-------+--------------------------------------
    22 | 345
    12 |  
     4 | qwe@efd.r
    12 |  
    12 | '
    12 |  
    14 | http://
     6 | www.com
    12 | /
    12 |  
    14 | http://
     5 | aew.werc.ewr/?ad=qwe&dw
     6 | aew.werc.ewr
    18 | /?ad=qwe&dw
    12 |  
     5 | 1aew.werc.ewr/?ad=qwe&dw
     6 | 1aew.werc.ewr
    18 | /?ad=qwe&dw
    12 |  
     6 | 2aew.werc.ewr
    12 |  
    14 | http://
     5 | 3aew.werc.ewr/?ad=qwe&dw
     6 | 3aew.werc.ewr
    18 | /?ad=qwe&dw
    12 |  
    14 | http://
     6 | 4aew.werc.ewr
    12 |  
    14 | http://
     5 | 5aew.werc.ewr:8100/?
     6 | 5aew.werc.ewr
    18 | :8100/?
    12 |   
     1 | ad
    12 | =
     1 | qwe
    12 | &
     1 | dw
    12 |  
     5 | 6aew.werc.ewr:8100/?ad=qwe&dw
     6 | 6aew.werc.ewr
    18 | :8100/?ad=qwe&dw
    12 |  
     5 | 7aew.werc.ewr:8100/?ad=qwe&dw=%20%32
     6 | 7aew.werc.ewr
    18 | :8100/?ad=qwe&dw=%20%32
    12 |  
     7 | +4.0e-10
    12 |  
     1 | qwe
    12 |  
     1 | qwe
    12 |  
     1 | qwqwe
    12 |  
    20 | 234.435
    12 |  
    22 | 455
    12 |  
    20 | 5.005
    12 |  
     4 | [e-mail]
    12 |  
    16 | qwe-wer
    11 | qwe
    12 | -
    11 | wer
    12 |  
     1 | asdf
    12 |  
    13 |  
     1 | qwer
    12 |  
     1 | jf
    12 |  
     1 | sdjk
    13 |  
    12 |  
     3 | ewr1
    12 | >
    12 |  
     3 | ewri2
    12 |  
    13 |  
    12 | 

    19 | /usr/local/fff
    12 |  
    19 | /awdf/dwqe/4325
    12 |  
    19 | rewt/ewr
    12 |  
     1 | wefjn
    12 |  
    19 | /wqe-324/ewr
    12 |  
     6 | gist.h
    12 |  
     6 | gist.h.c
    12 |  
     6 | gist.c
    12 | .
    12 |  
     1 | readline
    12 |  
    20 | 4.2
    12 |  
    20 | 4.2
    12 | .
    12 |  
    20 | 4.2
    12 | ,
    12 |  
    15 | readline-4
    11 | readline
    12 | -
    20 | 4.2
    12 |  
    15 | readline-4
    11 | readline
    12 | -
    20 | 4.2
    12 | .
    12 |  
    22 | 234
    12 |  

    13 |  
    12 |  
     1 | wow
    12 |   
    12 | <
    12 |  
     1 | jqw