QuoteSQL
Sybren Stuvel
sybrenUSE at YOURthirdtower.com.imagination
Tue Sep 26 06:02:56 EDT 2006
Lawrence D'Oliveiro enlightened us with:
> Because quoting the wildcards introduces backslash specials before
> each wildcard. Quoting non-wildcards then causes those backslashes
> to be doubled, which means they escape themselves instead of the
> wildcards.
I don't know about other DBMSes, but in PostgreSQL you can use any
escape character for the pattern, check out
http://www.postgresql.org/docs/8.0/interactive/functions-matching.html
Sybren
--
Sybren Stüvel
Stüvel IT - http://www.stuvel.eu/
More information about the Python-list
mailing list