Re: LIKE indexing proposal - Mailing list pgsql-hackers

From Zeugswetter Andreas SB SD
Subject Re: LIKE indexing proposal
Date
Msg-id 46C15C39FEB2C44BA555E356FBCD6FA4961FA8@m0114.s-mxs.net
Whole thread Raw
In response to LIKE indexing proposal  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
> The objection last time was that, according to the SQL standard, LIKE
> patterns should use the locale-specific collation order for the fixed
> parts (instead of character-by-character comparisons),

Yes, I think that LIKE definitely needs to be character-by-character
and I can think of no example in the german language that would make
general sense (like ss and single byte sharp s (ß) would definitely be
nonsense if handled as equal for LIKE).

Andreas



pgsql-hackers by date:

Previous
From: "Zeugswetter Andreas SB SD"
Date:
Subject: Re: LIKE indexing proposal
Next
From: Bruno Wolff III
Date:
Subject: Re: Scheduled jobs