\W excludes underscore

2019-05-07 Thread Erwin Brandstetter
https://www.postgresql.org/docs/current/functions-matching.html#POSIX-CLASS-SHORTHAND-ESCAPES-TABLE Table 9.19. Regular Expression Class-shorthand Escape: > \w [[:alnum:]_] (note underscore is included) > ... > \W [^[:alnum:]_] (note underscore is included) This is misleading as \w *includes* und

Re: \W excludes underscore

2019-05-07 Thread David G. Johnston
On Tue, May 7, 2019 at 4:36 PM Erwin Brandstetter wrote: > > https://www.postgresql.org/docs/current/functions-matching.html#POSIX-CLASS-SHORTHAND-ESCAPES-TABLE > Table 9.19. Regular Expression Class-shorthand Escape: > > > \w [[:alnum:]_] (note underscore is included) > > ... > > \W [^[:alnum:]_