Re: replace - Mailing list pgadmin-support

From Alexander Yerenkow
Subject Re: replace
Date
Msg-id CAPJF9w=XeXwpQqy7QDHP5goEsJpr=0fwNcBd9Y_8ayLfFyFVJA@mail.gmail.com
Whole thread Raw
In response to Re: replace  (ingoos <ingoos@gmail.com>)
Responses Re: replace
List pgadmin-support
<p dir="ltr">Put letter E before each string.<p dir="ltr">E'\'<p dir="ltr">Like this.<p dir="ltr">Regards, Alexander
Yerenkow<divclass="gmail_quote">20.08.2013 16:02 пользователь "ingoos" <<a
href="mailto:ingoos@gmail.com">ingoos@gmail.com</a>>написал:<br type="attribution" /><blockquote class="gmail_quote"
style="margin:00 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"> 9.2.4. ??<br /><br /> i'm using pgAdmin 1.16.1<br
/><br/> and error is<br /><br /> WARNING:  nonstandard use of escape in a string literal<br /> LINE 1: select replace
('abcd\efg','\', 'XX');<br />                         ^<br /> HINT:  Use the escape string syntax for escapes, e.g.,
E'\r\n'.<br/> WARNING:  nonstandard use of \' in a string literal<br /> LINE 1: select replace ('abcd\efg', '\',
'XX');<br/>                                     ^<br /><br /><br /><br /><br /><br /> --<br /> View this message in
context:<a href="http://postgresql.1045698.n5.nabble.com/replace-tp5768024p5768044.html"
target="_blank">http://postgresql.1045698.n5.nabble.com/replace-tp5768024p5768044.html</a><br/> Sent from the
PostgreSQL- pgadmin support mailing list archive at Nabble.com.<br /><br /><br /> --<br /> Sent via pgadmin-support
mailinglist (<a href="mailto:pgadmin-support@postgresql.org">pgadmin-support@postgresql.org</a>)<br /> To make changes
toyour subscription:<br /><a href="http://www.postgresql.org/mailpref/pgadmin-support"
target="_blank">http://www.postgresql.org/mailpref/pgadmin-support</a><br/></blockquote></div> 

pgadmin-support by date:

Previous
From: ingoos
Date:
Subject: Re: replace
Next
From: Rui Hua
Date:
Subject: Re: replace