RE: [HACKERS] Progress report on locale safe LIKE indexing

[Peter Eisentraut]

Hiroshi Inoue writes:

> Isn't 'a' LIKE 'A' if 'a' = 'A' ?

Yes.  But 'a' <> 'A'.

> LIKE seems to use the collating sequence.

No.  The collating sequence defines the order of all possible strings.
LIKE doesn't order anything.

-- 
Peter Eisentraut   [EMAIL PROTECTED]   http://funkturm.homeip.net/~peter


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html