Re: Does postgresql 9.0.4 use index on PREFIX%SUFFIX queries?

From: Alban Hertroys <haramrae(at)gmail(dot)com>
To: Edson Carlos Ericksson Richter <richter(at)simkorp(dot)com(dot)br>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Does postgresql 9.0.4 use index on PREFIX%SUFFIX queries?
Date: 2011-09-26 15:36:35
Message-ID: CAF-3MvOHrLA1O=F9mF9GRhN2m8ys7Br4bCCuDtkGYi0e6uh0Kg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 26 September 2011 17:15, Edson Carlos Ericksson Richter
<richter(at)simkorp(dot)com(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andy Chambers 2011-09-26 15:59:09 Batching up data into groups of n rows
Previous Message MirrorX 2011-09-26 15:28:08 Re: upgrade postgres to 8.4.8, centos 5.3