Thorsten <ThorstenNRW(at)gmx(dot)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