Postgres Pro
Downloads
Home   >   mailing lists

RE: Possible solution for LIKE optimization - Mailing list pgsql-hackers

From Peter Eisentraut
Subject RE: Possible solution for LIKE optimization
Date
Msg-id Pine.LNX.4.30.0108062105201.680-100000@peter.localdomain
Whole thread Raw
In response to RE: Possible solution for LIKE optimization  ("Hiroshi Inoue" <Inoue@tpf.co.jp>)
Responses Re: Possible solution for LIKE optimization
List pgsql-hackers
Tree view 
Hiroshi Inoue writes:

> I'm not familiar with non_ASCII locale.
> Is 'ss'  always guaranteed to be LIKE 's%'  for example ?

Yes.  LIKE doesn't use any collation rules, since it doesn't do any
collating.

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

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Possible solution for LIKE optimization
Next
From: Tom Lane
Date:
Subject: Re: OID wraparound: summary and proposal