Re: Detecting repeated phrase in a string

On 2021-12-09 16:11:31 +0100, Andreas Joseph Krogh wrote: > 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. See

Re: Detecting repeated phrase in a string

På torsdag 09. desember 2021 kl. 15:46:05, skrev Shaozhong SHI < 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

Re: Detecting repeated phrase in a string

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. Regards, David On Thu, 9 Dec 2021 at 13:35, Peter J. Holzer wrote: > On 2021-12-09 12:38:15 +, Shaozhong SHI

Re: Detecting repeated phrase in a string

On 2021-12-09 12:38:15 +, Shaozhong SHI wrote: > Does anyone know how to detect repeated phrase in a string? Use regular expressions with backreferences: bayes=> select regexp_match('foo wikiwiki bar', '(.+)\1'); ╔══╗ ║ regexp_match ║ ╟──╢ ║ {o} ║

Detecting repeated phrase in a string

Does anyone know how to detect repeated phrase in a string? Is there any such function? Regards, David