Re: Full Text Search German Date

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Full Text Search German Date
Дата
Msg-id 3061138.1748097432@sss.pgh.pa.us
обсуждение исходный текст
Список pgsql-sql
Thorsten <ThorstenNRW@gmx.de> writes:
> I create a tsvector (in a column named "search") from document files, 
> which contain a German date. When I select the column, I can see it has 
> been tokenized:
> '25.05.2025':56,99 (plus many other tokens)
> but
> SELECT id FROM documents WHERE
> search @@ to_tsquery('german', '25.05.2025')
> gives no result.

What is the plan for that query --- is it using an index?
Maybe the index is corrupt, in which case REINDEX could fix it.

            regards, tom lane



В списке pgsql-sql по дате отправления: