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