On Tue, Dec 16, 2003 at 04:32:37PM +0100, Peter Eisentraut wrote:
> Bruce Momjian wrote:
> > He is reminding folks about double-backslashes in a relivant place
> > --- makes sense to me.
>
> The relevant place would be far below where it already says:
>
> Note: Keep in mind that an escape's leading \ will need to be
> doubled when entering the pattern as an SQL string constant.
>
> So it's already covered.
With all due respect, Peter, it is only implicit in the docs, and that
is not always good enough. An explicit example will help, as
PostgreSQL's quoting system would qualify for an early place on the
'gotchas' page (cf. http://sql-info.de/mysql/gotchas.html) if
PostgreSQL had one.
Cheers,
D
--
David Fetter david@fetter.org http://fetter.org/
phone: +1 510 893 6100 cell: +1 415 235 3778