Postgres Pro
Downloads
Home   >   mailing lists

Re: Regular Expression For Duplicate Words - Mailing list pgsql-general

From Jian He
Subject Re: Regular Expression For Duplicate Words
Date
Msg-id CAMV54g1x=PDL4QPfp_BmBd93KtFfndG-SmK+hhvdQd-PW=VtaA@mail.gmail.com
Whole thread Raw
In response to Re: Regular Expression For Duplicate Words  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Tree view

It's an interesting question. But I also don't know how to do it in PostgreSQL.
But I figured out alternative solutions.

GNU Grep:    grep -E '(hello)[[:blank:]]+\1' <<<'one hello hello world'
ripgrep:     rg  '(hello)[[:blank:]]+\1' --pcre2  <<<'one hello hello world'

On Wed, Feb 2, 2022 at 8:53 PM David G. Johnston <david.g.johnston@gmail.com> wrote:
On Wed, Feb 2, 2022 at 1:00 AM Shaozhong SHI <shishaozhong@gmail.com> wrote:
This link is interesting.


Is there any example in Postgres?


Not that I'm immediately aware of, and I'm not going to search the internet for you.

The regex capabilities in PostgreSQL are pretty full-featured so a solution should be possible.  You should try translating the SO post concepts into PostgreSQL yourself and ask specific questions if you get stuck.

David J.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: pg_basebackup with hostssl ?
Next
From: Laura Smith
Date:
Subject: Re: pg_basebackup with hostssl ?