Postgres Pro
Downloads
Home   >   mailing lists

order of (escaped) characters in regex range - Mailing list pgsql-general

From InterRob
Subject order of (escaped) characters in regex range
Date
Msg-id CA+DVeYDq5zHNmJwf5t8gtqPhZ0uCgX5qXXnQP2vV4_EtK_Y7rA@mail.gmail.com
Whole thread Raw
Responses Re: order of (escaped) characters in regex range  (Szymon Guz <mabewlun@gmail.com>)
List pgsql-general
Tree view
Dear List,

I found this interesting:

SELECT regexp_matches('123-A' , E'(3[A-Z\- ])');
ERROR:  invalid regular expression: invalid character range

whereas:
SELECT regexp_matches('123-A' , E'(3[\- A-Z])');
 regexp_matches
----------------
 {3-}
(1 row)

Notice the order of (escaped) characters and ranges in the last bit of the expression.

Am I missing some key concept of the regular expression?

Regards,
Rob

pgsql-general by date:

Previous
From: Dave Cramer
Date:
Subject: Re: WAL file accumulation on log shipping primary node
Next
From: Szymon Guz
Date:
Subject: Re: order of (escaped) characters in regex range