PostgreSQL REGEXP_REPLACE Brackets

Question

Why would this one work:

SELECT REGEXP_REPLACE(REGEXP_REPLACE('[GREY]', '\]', ''), '\[', '')

But these not:

SELECT REGEXP_REPLACE('[GREY]', '[\[\]]', '')
SELECT REGEXP_REPLACE('[GREY]', '/[\[\]]/g', '')

This is the explanation from regex101.com:

/[\[\]]/g

Match a single character present in the list below [\[\]]
    \[ matches the character [ literally (case sensitive)
    \] matches the character ] literally (case sensitive)

Global pattern flags
    g modifier: global. All matches (don't return after first match)

And Match Information:

Match 1
    Full match  0-1 `[`
Match 2
    Full match  5-6 `]`

404 · Accepted Answer · 2018-04-04 17:16:28Z

3

REGEXP_REPLACE takes flags e.g. g as a separate parameter:

SELECT REGEXP_REPLACE('[GREY]', '[\[\]]', '', 'g') returns GREY

answered Apr 4, 2018 at 17:16

404

8,7622 gold badges33 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PostgreSQL REGEXP_REPLACE Brackets

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related