Request a Demo
Home   >   mailing lists

Full Text Search German Date - Mailing list pgsql-sql

From Thorsten
Subject Full Text Search German Date
Date
Msg-id 8eb428fc-50ba-4b63-a509-6f50a8951a07@gmx.de
Whole thread Raw
List pgsql-sql
Tree view
I encountered a problem I don't understand.

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?

pgsql-sql by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Confirming precedence order of Default for GUCs
Next
From: Tom Lane
Date:
Subject: Re: Full Text Search German Date