John R Pierce <pierce@xxxxxxxxxxxx> writes: > Bill Moran wrote: >> You need to spend some quality time with the documentation. Seriously, >> the issue _is_ confusing, but the docs explain it all, if you take the >> time to read all of it. > and, naturally, this gets even more complicated and confusing when the > string is a literal in a C/Perl/etc program that has its OWN escaping > going on. ... which is why we invented "dollar quoting". That's even less standard than anything else, but it is tremendously useful when you'd otherwise have to deal with multiple layers of escaping rules. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
