| From: | Thorsten <ThorstenNRW(at)gmx(dot)de> |
|---|---|
| To: | pgsql-sql(at)lists(dot)postgresql(dot)org |
| Subject: | Full Text Search German Date |
| Date: | 2025-05-24 07:51:00 |
| Message-ID: | 8eb428fc-50ba-4b63-a509-6f50a8951a07@gmx.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2025-05-24 14:37:12 | Re: Full Text Search German Date |
| Previous Message | David G. Johnston | 2025-05-21 13:52:14 | Re: Confirming precedence order of Default for GUCs |