Re: regexp_replace double quote

On Mon, Aug 15, 2016 at 9:27 AM, Михаил <m(dot)nasedkin(at)gmail(dot)com> wrote:

> Hi!
>
> I need to escape double quotes only:
> test=# select regexp_replace('"""{Performer,"Boomwacker ""a""
> Recording""}"""', '([^"])"{2}([^"])', '\1\"\2', 'g');
> regexp_replace
> -------------------------------------------------
> """{Performer,"Boomwacker \"a"" Recording\"}"""
>

What is the goal you are trying to accomplish​. Its possible to do what
you ask but only if no other solution is feasible.

> This is unexpected result.
>
> But when added one symbol to ""a"" the result is right:
> test=# select regexp_replace('"""{Performer,"Boomwacker ""a1""
> Recording""}"""', '
> ​​
> ([^"])"{2}([^"])', '\1\"\2', 'g');
> regexp_replace
> --------------------------------------------------
> """{Performer,"Boomwacker \"a1\" Recording\"}"""
>
>
<​
​
([^"])"{2}([^"])> on < ""a""> consumes < ""a>​ leaving <""> which doesn't
match your pattern since there is nothing before the double-quote to
satisfy the [^"]

See depesz's simultaneous post for the solution using look-ahead.

David J.