Am 06.01.2012 um 22:56 schrieb Adam D. Barratt:
> On Fri, 2012-01-06 at 22:39 +0100, Axel Rau wrote:
>> "The quote_pgsql expansion operator, in addition, escapes the percent
>> and underscore characters."
>> Why do we take percent and underscore special?
>
> They're SQL wildcard characters - see
> http://www.w3schools.com/sql/sql_wildcards.asp for instance.
Only in a LIKE or ILIKE clause.
>
>> Is this a bug?
>
> No, it's a necessary feature.
Quote continuing: "This cannot be done
for MySQL because these escapes are not recognized in contexts where these
characters are not special."
Seems to me, pgsql behaviour has changed with 9.x into same direction.
Axel
---
PGP-Key:29E99DD6 ☀ +49 151 2300 9283 ☀ computing @ chaos claudius
