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@xxxxxxxxxx <mailto:andreas@xxxxxxxxxx>
www.visena.com <https://www.visena.com>
<https://www.visena.com>
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
