BUG #14415: non-breaking space matching in regex as whitespace
The following bug has been logged on the website:
Bug reference: 14415
Logged by: Valery Guskov
Email address: valerijs.gusjkovs@gmail.com
PostgreSQL version: 9.6.0
Operating system: RedHat
Description:
This was workng on 9.4 at least, but does not in 9.6. Followind returns
should be reversed as non-breaking space is whitespace:
select 'Web project experience' ~* 'Web\S+' as pew;
pew
-----
t
(1 row)
_______________________________________________
select 'Web project experience' ~* 'Web\s+' as pew;
pew
-----
f
(1 row)
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
valerijs.gusjkovs@gmail.com writes:
This was workng on 9.4 at least, but does not in 9.6. Followind returns
should be reversed as non-breaking space is whitespace:
What encoding and LC_CTYPE are you using? AFAIR we haven't changed
anything about that code behavior since 9.4, so the most likely theory
is that your 9.6 installation is using a locale/encoding that doesn't
consider NBSP to be whitespace --- as C locale wouldn't, for example.
regards, tom lane
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs