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. +