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.0108181816450.677-100000@peter.localdomain
Whole thread Raw
In response to RE: Progress report on locale safe LIKE indexing  ("Hiroshi Inoue" <Inoue@tpf.co.jp>)
Responses RE: Progress report on locale safe LIKE indexing
List pgsql-hackers
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   peter_e@gmx.net   http://funkturm.homeip.net/~peter



pgsql-hackers by date:

Previous
From: "Hiroshi Inoue"
Date:
Subject: RE: Progress report on locale safe LIKE indexing
Next
From: "August Zajonc"
Date:
Subject: Re: Setting Up User Accounts For PostgreSQL ?