Re: regex match and special characters

2018-08-18 Thread Oleksii Kliukin
> On 16. Aug 2018, at 16:57, Tom Lane wrote: > > Alex Kliukin writes: >> Here is a simple SQL statement that gives different results on PostgreSQL >> 9.6 and PostgreSQL 10+. The space character at the end of the string is >> actually U+2006 SIX-PER-EM SPACE >> (http://www.fileformat.info/inf

Re: regex match and special characters

2018-08-18 Thread Oleksii Kliukin
Hi Adrian, > On 16. Aug 2018, at 18:13, Adrian Klaver wrote: > > test=# select 'abcd'||chr(8198) ~ 'abcd\s'; > ?column? > -- > t > (1 row) > > > Wonder if the OP has standard_conforming_strings='off' and > escape_string_warning='off'? > Both are set to ‘on’ for me for all versions (I