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(at)xs4all(dot)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
>
>
>