| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | John R Pierce <pierce(at)hogranch(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org, "Patrick M(dot) Rutkowski" <rutski89(at)gmail(dot)com> |
| Subject: | Re: WARNING: nonstandard use of escape in a string literal |
| Date: | 2009-12-23 21:20:58 |
| Message-ID: | 14032.1261603258@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
John R Pierce <pierce(at)hogranch(dot)com> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2009-12-23 21:43:11 | Re: How to add month.year column validation |
| Previous Message | John R Pierce | 2009-12-23 21:13:30 | Re: WARNING: nonstandard use of escape in a string literal |