På torsdag 09. desember 2021 kl. 15:46:05, skrev Shaozhong SHI < shishaozh...@gmail.com <mailto:shishaozh...@gmail.com>>:
Hi, Peter, How to define word boundary as either by using ^ , space, or $ So that the following can be done fox fox is a repeat foxfox is not a repeat but just one word. Do you want repeated phrase (list of words) ore repeated words? For repeated words (including unicode-chars) you can do: (\b\p{L}+\b)(?:\s+\1)+ I'm not quite sure how to translate this to PG, but in JAVA it works. -- Andreas Joseph Krogh CTO / Partner - Visena AS Mobile: +47 909 56 963 andr...@visena.com <mailto:andr...@visena.com> www.visena.com <https://www.visena.com> <https://www.visena.com>