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.
But this query returns true: select to_tsvector('german', 'bla baum haus 25.05.2025 blub fahrrad') @@ to_tsquery('german', '25.05.2025')
And also the following query returns true: select '25.05.2025:1 blub:2'::tsvector @@ to_tsquery('german', '25.05.2025')
Can someone explain me, why my query on the database fails?