Escape rather than filter SIMILAR TO metacharacters in patron crazy search
authordbs <dbs@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Thu, 14 Apr 2011 18:19:43 +0000 (18:19 +0000)
committerdbs <dbs@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Thu, 14 Apr 2011 18:19:43 +0000 (18:19 +0000)
commitdd18a6d84ed61c720c781bb27d443223d8443116
tree0cb2f73ffc5546eeb746fb1df6a678f13d5c3022
parent876524426bb74e4e8767be64707481bc2fc812c1
Escape rather than filter SIMILAR TO metacharacters in patron crazy search

The filtering I introduced in r19983 was overly aggressive, and included
characters that weren't actually SIMILAR TO metacharacters. Instead, escape
each character, carefully going through the list of metacharacters listed at
http://www.postgresql.org/docs/8.4/interactive/functions-matching.html

Works for email addresses like "foo.bar+baz@example.com".

git-svn-id: svn://svn.open-ils.org/ILS/branches/rel_2_1@20086 dcc99617-32d9-48b4-a31d-7c20da2025e4
Open-ILS/src/perlmods/lib/OpenILS/Application/Storage/Publisher/actor.pm