Horton

Re: Full Text Search German Date

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Thorsten <ThorstenNRW@gmx.de>
Cc: pgsql-sql@lists.postgresql.org
Date: 2025-05-24T14:37:12Z
Lists: 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