Re: regex match and special characters

On 08/18/2018 08:12 AM, Oleksii Kliukin wrote:
> Hi Adrian,
> 
>> On 16. Aug 2018, at 18:13, Adrian Klaver <adrian.klaver@aklaver.com 
>> <mailto:adrian.klaver@aklaver.com>> 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 believe those are 
> default settings). I have 12devel indeed on my test system alongside 
> 9.6, but I’ve tried it as well on PostgreSQL 10 running on a different 
> distro with different locale settings and it produced the same result 
> (check being true).
> 
> I think Tom’s answer solves it, although I am wondering how did you get 
> true in the statement quoted above on PostgreSQL 9.6, perhaps that 
> result is actually from PostgreSQL 10?

Yes it was on Postgres 10. I got reversed in my thinking. A subsequent post:

https://www.postgresql.org/message-id/8b8d9250-1ee3-6aff-b580-592c7c759586%40aklaver.com

shows the behavior you saw on 9.6. What happens when I work through my 
thought process on line:(

> 
> Cheers,
> Oleksii


-- 
Adrian Klaver
adrian.klaver@aklaver.com