Обсуждение: replace

i need to convert some stings in old database, where \ is one letter in
croatian language. 

when i'm using 

replace ('abcd\efg', '\', 'XX') i got error. 

anyone can help how to solver this problem ?

tnx



--
View this message in context: http://postgresql.1045698.n5.nabble.com/replace-tp5768024.html
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.

9.2.4. ??

i'm using pgAdmin 1.16.1

and error is 

WARNING:  nonstandard use of escape in a string literal
LINE 1: select replace ('abcd\efg', '\', 'XX');                       ^
HINT:  Use the escape string syntax for escapes, e.g., E'\r\n'.
WARNING:  nonstandard use of \' in a string literal
LINE 1: select replace ('abcd\efg', '\', 'XX');                                   ^





--
View this message in context: http://postgresql.1045698.n5.nabble.com/replace-tp5768024p5768044.html
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.

Put letter E before each string.

E'\'

Like this.

Regards, Alexander Yerenkow

Put letter E before each string.

E'\'

Like this.

Regards, Alexander Yerenkow

20.08.2013 16:02 пользователь "ingoos" <ingoos@gmail.com> написал:

9.2.4. ??

i'm using pgAdmin 1.16.1

and error is

WARNING:  nonstandard use of escape in a string literal
LINE 1: select replace ('abcd\efg', '\', 'XX');
                        ^
HINT:  Use the escape string syntax for escapes, e.g., E'\r\n'.
WARNING:  nonstandard use of \' in a string literal
LINE 1: select replace ('abcd\efg', '\', 'XX');
                                    ^





--
View this message in context: http://postgresql.1045698.n5.nabble.com/replace-tp5768024p5768044.html
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.


--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support