Re: How best to work around the issue - regex string cannot contain brackets - Mailing list pgsql-sql

From Steve Midgley
Subject Re: How best to work around the issue - regex string cannot contain brackets
Date
Msg-id CAJexoS+QpHS3tdn9ff7kfVYqXmEFhw3=8zV-ZM8K8UW0JLkg8Q@mail.gmail.com
Whole thread Raw
In response to Re: How best to work around the issue - regex string cannot contain brackets  (Shaozhong SHI <shishaozhong@gmail.com>)
Responses Re: How best to work around the issue - regex string cannot contain brackets  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-sql


On Fri, Feb 4, 2022 at 6:01 AM Shaozhong SHI <shishaozhong@gmail.com> wrote:
It appears that the following regex work differently.

Why \d and [\d] are different?

[A-PR-UWYZ]\d{1,2} and [A-PR-UWYZ][\d]{1,2}


This is getting into regex stuff, where maybe stackoverflow is a better resource? But when you put characters into brackets, you are telling regex to search for each character represented in the bracket. So [\d] is looking for any single character that is either a \ or a d character. Outside of brackets, regex evaluates \d as any digit. For US English charset [0-9] is equivalent to \d I believe.

pgsql-sql by date:

Previous
From: Shaozhong SHI
Date:
Subject: Re: How best to work around the issue - regex string cannot contain brackets
Next
From: "David G. Johnston"
Date:
Subject: Re: How best to work around the issue - regex string cannot contain brackets