Re: Sv: Re: Sv: Re: regex match and special characters

On 08/16/2018 08:19 AM, Adrian Klaver wrote:
> On 08/16/2018 08:13 AM, Adrian Klaver wrote:
> 
>>
>>
>> Wonder if the OP has standard_conforming_strings='off' and
>> escape_string_warning='off'?
> 
> In the above referring to 9.6.9 instance.

Well that theory is no good:

test=# select version();
                                        version 

-------------------------------------------------------------------------------------
  PostgreSQL 9.6.7 on x86_64-pc-linux-gnu, compiled by gcc (SUSE Linux) 
4.8.5, 64-bit
(1 row)


test=# set standard_conforming_strings='off';
SET
test=# show standard_conforming_strings;
  standard_conforming_strings
-----------------------------
  off

test=# show escape_string_warning;
  escape_string_warning
-----------------------
  off


test=# select 'abcd'||chr(8198) ~ E'abcd\s';
  ?column?
----------
  f
(1 row)

test=# select 'abcd'||chr(8198) ~ E'abcd\\s';
  ?column?
----------
  f
(1 row)

test=# set escape_string_warning='on';
SET
test=# set standard_conforming_strings='on';
SET


test=# select 'abcd'||chr(8198) ~ 'abcd\s';
  ?column?
----------
  f
(1 row)

test=# select 'abcd'||chr(8198) ~ E'abcd\\s';
  ?column?
----------
  f
(1 row)




>>
>>
>>
>>> -- 
>>> *Andreas Joseph Krogh*
>>> CTO / Partner - Visena AS
>>> Mobile: +47 909 56 963
>>> andreas@visena.com <mailto:andreas@visena.com>
>>> www.visena.com <https://www.visena.com>
>>> <https://www.visena.com>
>>
>>
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com