Content-Type: multipart/alternative;
 boundary="------------Q23xUFb8jEB7TIOKQ2CKEcaC"
Message-ID: <8eb428fc-50ba-4b63-a509-6f50a8951a07@gmx.de>
Date: Sat, 24 May 2025 09:51:00 +0200
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Content-Language: en-US, de-DE
To: pgsql-sql@lists.postgresql.org
From: Thorsten <ThorstenNRW@gmx.de>
Subject: Full Text Search German Date
UI-OutboundReport: notjunk:1;M01:P0:f1s7H0uFo7k=;EDj5XHr1CS9keLbycaxiua4vayH
 nabl1W+VXoZjHFnGJIw3/+uRNzPmO6/Dpyf3i9fA2Uux96V1gUtsa94/YxCYbitdB7wMndhRz
 MyYOws8ru4exQxkLnjPXGgPf6u5GFSCCLvlXAVfQO5OKOgE6gnZgeCedpA9px71NhixIZqFQU
 eXHJVGgdbPP+xlvQWL+F8ogdxH6r1YcPp8aDBybu46tdwYpR6inS5q6vbMiZpUJMG3bHGfGa9
 GleU/KeQHrOsFPN5E4GH6HJr7G/oW5Dis8xAoU8vhQtDBJuHJY/g3buFRWGTmtAjPyFUxXkEK
 lzjC+WYFAytvpaCg88v9P8pDOveTBz929g0O8GuK99K38YpJTB9nxEDE+7l+snSRAagKtfBAK
 HJy1Oomb1Fv0rigNUQj1Cc7FZt15I+6vETW0LFpeL8l7Ke4sgAN7IF6ZQtgYmashPyhxOuyNK
 lSXyy+RpY5RSFrMMaa/CmGjf6OFjG9fn7ARrdp7+FyEO4QbHbx6QBALLfVr24S5ZEibXWUNX6
 x1bs2NRGsVvXu6qr1pU2UGaiTG7prXUTCPc7ZJ580vueMp3c3+EFi/GvevG2gjcItWZG6Rr3t
 bEdk3aQPrgCkX9nlb4MrGMFI0E47wNcWiL3C86PFmheNhx5oKuW/ceylceWpwryI3bKJu9x3N
 bOwXPynkZJqrDeDB80MOvuI+atcjVHz5lkL/5XnZS3DDQatawYyh47b8fra9bNYVD4zgfAarG
 yPxnWHzQzrKfwznlWjajCu35OZ5rVGRUPPafwbkFmG4Q5y+Gj63y0332KvmlOT21YBI1//+Dv
 hPV4MwdssNXb2qlOugKzkihXoU8w/QoZrSGRHi7kJ88LZWmsmiF2bmQU4fNyws8pO5mJBQXpf
 lKVnlW+HJEY4vSRPs5Ho0+AxHFW31bELTdDzFgbFOzUn9IUa2WJIt91fJ+UBS1bVBse/NuBlR
 uuIVr7VBUYNJMGkEDAKZWsX+0yBlOcp5ZJVYPscMf+vYI6zf0hgv1tu0mXy2Y9XO+gNDz8OS6
 samVmN02VyQpt6mISY41BxEK+tIOJhCp0UH1syE/ejGgqjTHTTQcugHe0kt68CvXvMqYIm3lW
 yMlqbyC9jpvwgbRmteARiDSYCO2HMELhYXlFF5u6ptLLRuyBMeagl9wtpmIi9lHxLJGAcjzBG
 oJlHF4AA50rPXXBuebrjVd+yBot0yQkix+r8s0ItZX8h7npWwFKYVw4uqd/Jxhfft9NlukWvM
 fWh0nP9yXqP/c2BaALE/888brWsWh4gJlrnz1LnDc1Y4ch+99FRQ/MmAipg44pUEf/WqNPMEG
 aAsNtZuL66plxSy+u5cloCERoJC/yWxnLsMyhIu0RQZEQDfC6a3yTgw1er0gUNgARu0ue19si
 p7Ne/RHt4JSU2M90szlV5t3tZgkUIEsPb+FColmpIP4E7Jq7n5U2iFD+OHTZ+OICLsjhnLcxL
 uR4dWDH/PxybFNoRyLp9H4elrh14rES1WdJGNZGDx3Eq5WjB53I3KcCxYbBD3bYtHAG31pkHV
 c4H5N6OtCKg8FEW3wxpOrmFGzJF4J71zIgnNf36dSxx1jwruWw1oMvGdUniDR/XsTMCJa+PqU
 Q6AqZrbGzVoZy+mlP06FqQaJBU9lQrascbcX/hJFZ1fjkKFOfivyRczviyyuQukgSnT/rvMeF
 9tB8NMjMfTk9sTgVh/YAUYarmp9PcXB4FgGBnAzucaqXgyZbdaXinVlwq4bGtKxrAkTpl5Wn0
 B5BYb1DTqYdCEr5O7/TKrPHVMF5GgFeUF3nZgY4wlCTlpw+5nzpoatO2U48H2WFALhvddl5ij
 yatWstTr4UCN3Qcm3RQmLp9YejiR2pfs7gYplCxnS5tcPidTzRlu5HhJT3NSO7u/crnXAcA5V
 /jI+5+/imjOc7sdzS+REHr8WUytZWynEJWJNYl4wuiBqERCD+7IGoQIfYZx6z39reJ60kTxGe
 ngmzTOBRt+KcYcsDMbyT587Uw3k/tPm4cmVQdFqFfBWNSfWCGhF5RD3Spx571Wgw4KF/qQIN/
 XhQ19TbV7QiBPNBZd2cRtSRaV50swDqHQ0GzOsy8uXMBO0cw0OyMdQLTxAHO/Ira8jiG30sey
 888AqBnFkvcDjjZGTqMe1uOm0+ouCQNNvo4p3q1i5DvhEcC4aD1Eb1JU76Nu4egSSQGpQ/skj
 USa7/7SfukWspMDEbX0rhKlpZEM/sdvfv8aoFCcn+Mh6FquCAcsJEAdV918Qh6kX1lBz3Qc26
 rOi5UtzNvKdSJZU1Vt4Wdr+5th6YSNNUxiG3a+UiVFEqrfSLrOEwkoVDWenFocjc6i436CgAI
 mvWzxrMTqv8m8QCgx0S1adrSEJ4FhL9gPGxPhWfY3MTjBSM7Qm6lpRieYzrJHM/OjLsyZ28or
 TXaxW4g8qSaozHqOPsXKfmQ1XTnKgy7E9s+lApVSKplfUKlp17gBm9zk4TMPhhk/OIgbCLF0K
 HW9Zk49xt7Wc4xWEFxHHD32IavVH4hKHZZn0CD3tTfbt6+sn5caAEFs61ttaTOao+9cgCzTZt
 P/KKFq9oDeuZWzUaQISZRrjKCJZZ1cLUEqc7i71iyO69jFrDlvppZa6k3BcLKDJHOzpHc34G/
 G7OFJTEXkVYu6HOLRFgsKD7bwAWBSgQH+DPehD/2kEQ3cZ8/3QTjOgfViPOyUzK+Vsex7984z
 Y0znCi5rn2GAJo2NAP3iZbPMwGFi+gbdcHskxuGCS2V1LV5Mtk/PMcvFCnDk1SgNo4+r6crBi
 Ud0A5Mwcg0s82ZT2dH2W4NOaF+AK6VdOxTxN5W6j8f5Xvpoiu+iClWd4e8JS1DtL9nEAdg/S8
 eEp5h6ZecAURiJr3+sw+LzLfGIzPwBBVD3sa/nubilkuu3AHM454MafdM33IlkhQQmrj69xWW
 lHTfTeSuEtUXu71RhvVY7Bqfj5BBVi2U8sQWmBXIUshsCRpXQ7FHOEOScpqa8uiErOjkCQJhJ
 4q+VhYrg7fxqfbpsV5OXCc3Rmw5mFVMZB5F9FHVoKzEA0SIz7zzJwa2H+pnwAJRus5Wi+ekhW
 BiKMSJwFWFlm/5RgDw3bM7SlSh7CNMausjvlmeTNL7bVakiX2kfXjlCr4VqVkE+PV+5/3swQB
 122LCjMCojpfw49NI/MAvNh+CC64DwYa25wYMWIZBQcY5E/sLgUIbQQh7S4LDeW/wewGYf8/I
 xddA0KXCOul8agPX+jCAuOW57WWwj9TSev7uQJ6fEuHFnxwdmahv1aDnEYCZSME5w1NgS4MO4
 aYX7dmszjI4q5qlc
Archived-At: 
 <https://www.postgresql.org/message-id/8eb428fc-50ba-4b63-a509-6f50a8951a07%40gmx.de>
Precedence: bulk

This is a multi-part message in MIME format.
--------------Q23xUFb8jEB7TIOKQ2CKEcaC
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: quoted-printable

I encountered a problem I don't understand.

I create a tsvector (in a column named "search") from document files,=20
which contain a German date. When I select the column, I can see it has=20
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?

--------------Q23xUFb8jEB7TIOKQ2CKEcaC
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit

<!DOCTYPE html>
<html>
  <head>

    <meta http-equiv="content-type" content="text/html; charset=UTF-8">
  </head>
  <body>
    I encountered a problem I don't understand.<br>
    <br>
    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:<br>
    <br>
    '25.05.2025':56,99 (plus many other tokens)<br>
    <br>
    but<br>
    SELECT id FROM documents WHERE <br>
    search @@ to_tsquery('german', '25.05.2025')<br>
    <br>
    gives no result.<br>
    <br>
    But this query returns true:<br>
    select to_tsvector('german', 'bla baum haus 25.05.2025 blub
    fahrrad')<br>
    @@ to_tsquery('german', '25.05.2025')<br>
    <br>
    And also the following query returns true:<br>
    select '25.05.2025:1 blub:2'::tsvector @@ to_tsquery('german',
    '25.05.2025')<br>
    <br>
    Can someone explain me, why my query on the database fails?<br>
    <br>
  </body>
</html>

--------------Q23xUFb8jEB7TIOKQ2CKEcaC--