question about to_tsvector and to_tsquery

From: Martin Norbäck Olivers <martin(at)norpan(dot)org>
To: pgsql-sql(at)lists(dot)postgresql(dot)org
Subject: question about to_tsvector and to_tsquery
Date: 2021-08-24 12:01:23
Message-ID: CALoTC6u=g8Hs4GUq+0ZewHGKMdfcAUqM4wdaxFr2cezB09FvUg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Is there any more information on exactly how to_tsquery and to_tsvector are
supposed to work?

select to_tsvector('simple', '1.b') gives '1':1 'b':2
but
select to_tsvector('simple', '1.bb') gives '1.bb':1

select to_tsquery('simple', '1.b:*') gives '1':* & 'b':*
but
select to_tsquery('simple', '1.bb:*') gives '1.bb':*

Regards,
Martin

--
Martin Norbäck Olivers
IT-konsult, Masara AB
Telefon: +46 703 22 70 12
E-post: martin(at)norpan(dot)org
Kärrhöksvägen 4
656 72 Skattkärr

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2021-08-24 14:12:51 Re: question about to_tsvector and to_tsquery
Previous Message aditya desai 2021-08-24 06:49:13 Re: Partition by outer join