Re: [GENERAL] Question on replace function [solved]

2016-09-25 Thread Charles Clavadetscher
tgresql.org > Subject: Re: [GENERAL] Question on replace function [solved] > > On 09/25/2016 08:39 AM, Tom Lane wrote: > > Charles Clavadetscher writes: > >> Honestly I still don't understand why this happened this way. > > > > I wonder if you have standar

Re: [GENERAL] Question on replace function [solved]

2016-09-25 Thread Adrian Klaver
On 09/25/2016 08:39 AM, Tom Lane wrote: > Charles Clavadetscher writes: >> Honestly I still don't understand why this happened this way. > > I wonder if you have standard_conforming_strings turned off, or > did when that data was inserted. That would change the behavior > of backslashes in strin

Re: [GENERAL] Question on replace function [solved]

2016-09-25 Thread Tom Lane
Charles Clavadetscher writes: > Honestly I still don't understand why this happened this way. I wonder if you have standard_conforming_strings turned off, or did when that data was inserted. That would change the behavior of backslashes in string literals. regards, tom l

Re: [GENERAL] Question on replace function [solved]

2016-09-25 Thread Adrian Klaver
On 09/25/2016 05:45 AM, Charles Clavadetscher wrote: Hi Rob On 09/25/2016 01:39 PM, rob stone wrote: On Sun, 2016-09-25 at 10:29 +0200, Charles Clavadetscher wrote: Hello I am using PostgreSQL 9.4.7 on x86_64-unknown-linux-gnu, compiled by gcc (Debian 4.7.2-5) 4.7.2, 64-bit I imported data

Re: [GENERAL] Question on replace function [solved]

2016-09-25 Thread Charles Clavadetscher
Hi Rob On 09/25/2016 01:39 PM, rob stone wrote: > > On Sun, 2016-09-25 at 10:29 +0200, Charles Clavadetscher wrote: >> Hello >> >> I am using PostgreSQL 9.4.7 on x86_64-unknown-linux-gnu, compiled by >> gcc >> (Debian 4.7.2-5) 4.7.2, 64-bit >> >> I imported data from a MariaDB table into PostgreS

Re: [GENERAL] Question on replace function

2016-09-25 Thread rob stone
On Sun, 2016-09-25 at 10:29 +0200, Charles Clavadetscher wrote: > Hello > > I am using PostgreSQL 9.4.7 on x86_64-unknown-linux-gnu, compiled by > gcc  > (Debian 4.7.2-5) 4.7.2, 64-bit > > I imported data from a MariaDB table into PostgreSQL and noticed > that  > the content of a field was not c

[GENERAL] Question on replace function

2016-09-25 Thread Charles Clavadetscher
Hello I am using PostgreSQL 9.4.7 on x86_64-unknown-linux-gnu, compiled by gcc (Debian 4.7.2-5) 4.7.2, 64-bit I imported data from a MariaDB table into PostgreSQL and noticed that the content of a field was not correct, but I was not able to change it. The field is called vcard and is of dat