Re: regexp_replace weirdness amounts to a bug? - Mailing list pgsql-hackers

From Malthe
Subject Re: regexp_replace weirdness amounts to a bug?
Date
Msg-id CAAPh5F=-UBp3Bm2qL9A1DaOWq3pCF+5fw8DLw4KONhqMBFXZPw@mail.gmail.com
Whole thread Raw
In response to regexp_replace weirdness amounts to a bug?  (Erik Rijkers <er@xs4all.nl>)
List pgsql-hackers
Hi Erik,

The regexp doesn't match your string because you're not allowing for
any repeat characters, try adding a '+'.

On Wed, 16 Aug 2023 at 09:07, Erik Rijkers <er@xs4all.nl> wrote:
>
> Hello,
>
> The following surprised me enough to think it might be a bug:
> (17devel)
>
> select
>     regexp_replace('Abc Def'
>    , '([a-z]) ([A-Z])'
>    , '\1 ' || lower('\2')  );
>
> regexp_replace
> ----------------
>   Abc Def
> (1 row)
>
> -- 'Abc Def' got
> -- 'Abc def' expected
>
> What do you think?
>
> Thanks,
>
> Erik Rijkers
>
>
>



pgsql-hackers by date:

Previous
From: Erik Rijkers
Date:
Subject: regexp_replace weirdness amounts to a bug?
Next
From: jian he
Date:
Subject: Re: Normalization of utility queries in pg_stat_statements