Re: Detecting repeated phrase in a string
På torsdag 09. desember 2021 kl. 15:46:05, skrev Shaozhong SHI <shishaozhong@gmail.com>:
Hi, Peter,How to define word boundary as either by using^ , space, or $So that the following can be donefox fox is a repeatfoxfox 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
Вложения
В списке pgsql-general по дате отправления: