Re: regexp_replace weirdness amounts to a bug?

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
>
>
>