Postgres Pro
Downloads
Home   >   mailing lists

Re: Progress report on locale safe LIKE indexing - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Progress report on locale safe LIKE indexing
Date
Msg-id Pine.LNX.4.30.0108191427140.677-100000@peter.localdomain
Whole thread Raw
In response to Re: Progress report on locale safe LIKE indexing  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
Tom Lane writes:

> But the LIKE code does know about multibyte character sets.  Is it safe
> to assume that memcmp-based sorting will not make any mistakes with
> multibyte characters?

Remember that this memcmp-based sorting is the same sorting that texteq
will do when locale is turned off.  So if there were a problem it would
already exist, but I'm sure there isn't one.

-- 
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter

pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: RE: Progress report on locale safe LIKE indexing
Next
From: Karel Zak
Date:
Subject: Re: [PATCHES] encoding names