[HACKERS] Re: [PATCHES] LIKE indexing

2001-08-20 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > Tom Lane writes: >> The text does seem to say that it's okay to add trailing blanks to the >> pattern to produce a match, when the collating sequence is PAD SPACE >> type (bpchar in our terms). > I can't find that. The spec says "without the appendi

[HACKERS] Re: [PATCHES] LIKE indexing

2001-08-20 Thread Peter Eisentraut
Tom Lane writes: > How can A = B not imply A LIKE B? Well, according to my reading of the spec, it apparently can. Space padding can be weird that way. But see below why I think there are much worse alternatives. > 4) If the i-th substring specifier of PCV is neither an >