Postgres Pro
Downloads
Home   >   mailing lists

Re: Does postgresql 9.0.4 use index on PREFIX%SUFFIX queries? - Mailing list pgsql-general

From Alban Hertroys
Subject Re: Does postgresql 9.0.4 use index on PREFIX%SUFFIX queries?
Date
Msg-id CAF-3MvOHrLA1O=F9mF9GRhN2m8ys7Br4bCCuDtkGYi0e6uh0Kg@mail.gmail.com
Whole thread Raw
In response to RES: Does postgresql 9.0.4 use index on PREFIX%SUFFIX queries?  ("Edson Carlos Ericksson Richter" <richter@simkorp.com.br>)
Responses RES: Does postgresql 9.0.4 use index on PREFIX%SUFFIX queries?  ("Edson Carlos Ericksson Richter" <richter@simkorp.com.br>)
List pgsql-general
Tree view 
On 26 September 2011 17:15, Edson Carlos Ericksson Richter
<richter@simkorp.com.br> wrote:
> Just discovered, I can’t use GIST over character varying...

Why do you think that?

--
If you can't see the forest for the trees,
Cut the trees and you'll see there is no forest.

pgsql-general by date:

Previous
From: MirrorX
Date:
Subject: Re: upgrade postgres to 8.4.8, centos 5.3
Next
From: Andy Chambers
Date:
Subject: Batching up data into groups of n rows