Full text search randomly not working for short prefixes?
От
cen
Тема
Full text search randomly not working for short prefixes?
Дата
Msg-id
7f2f3977-1166-1cd7-63ec-c639c6f13d45@gmail.com
Список
Дерево обсуждения
Full text search randomly not working for short prefixes? cen <imbacen@gmail.com>
Re: Full text search randomly not working for short prefixes? Tom Lane <tgl@sss.pgh.pa.us>
Re: Full text search randomly not working for short
prefixes? cen <imbacen@gmail.com>
Re: Full text search randomly not working for short
prefixes? Andreas Joseph Krogh <andreas@visena.com>
Something funny going on with my full text search.. and I have no idea what.
I have a receiver called "Ana", this is her tsv column:
'38651000000':4 'aceventura@mailinator.com':3B 'ana':1A 'novak':2A
This queries do not find her:
SELECT * FROM receivers r WHERE r.tsv @@ to_tsquery(unaccent('a:*'));
SELECT * FROM receivers r WHERE r.tsv @@ to_tsquery(unaccent('an:*'));
This does:
SELECT * FROM receivers r WHERE r.tsv @@ to_tsquery(unaccent('ana:*'));
Now to an even more interesting part: I have 3 people with last name
"Novak" and one with name "Nov"
This query finds all 4:
SELECT * FROM receivers r WHERE r.tsv @@ to_tsquery(unaccent('n:*'));
This finds NONE:
SELECT * FROM receivers r WHERE r.tsv @@ to_tsquery(unaccent('no:*'));
This finds all 4 again:
SELECT * FROM receivers r WHERE r.tsv @@ to_tsquery(unaccent('nov:*'));
..and this finds all with the last name only:
SELECT * FROM receivers r WHERE r.tsv @@ to_tsquery(unaccent('nova:*'));
These are the TSV columns of last name:
"'38651000000':4 'janez':1A 'janeznovak@mailinator.com':3B 'novak':2A"
"'38651000000':4 'aceventura@mailinator.com':3B 'ana':1A 'novak':2A"
"'38651000000':4 'novak':2A 'tine':1A 'tnovak@mailinator.com':3B"
"'21415000000':4 'alen.nova@gmailer.com':3B 'allan':1A 'novak':2A"
And the first name:
"'38651604724':6 'brez':3A 'list':4A 'nov':1A
'novreceiver101@mailinator.com':5B 'receiv':2A"
What is going on here?
В списке pgsql-general по дате отправления