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