Re: [HACKERS] like/ilike improvements
Bruce Momjian <bruce@momjian.us>
From: Bruce Momjian <bruce@momjian.us>
To: Andrew Dunstan <andrew@dunslane.net>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Zeugswetter Andreas ADI SD <ZeugswetterA@spardat.at>, andrew@supernews.com, "Patches (PostgreSQL)" <pgsql-patches@postgresql.org>
Date: 2007-06-02T02:15:13Z
Lists: pgsql-hackers
Andrew Dunstan wrote: > > I'd suggest adding something like "If we are in the middle of a > > multibyte character, we must already have matched at least one byte of > > the character from both text and pattern; so we cannot get out-of-sync > > on character boundaries. And we know that no backend-legal encoding > > allows ASCII characters such as '%' to appear as non-first bytes of > > characters, so we won't mistakenly detect a new wildcard." > > > > > > > > Done, and committed. Woohoo, that's a big one off the plate! -- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. +