Re: TEXT column and indexing

From: Ian Barwick <barwick(at)gmx(dot)net>
To: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: TEXT column and indexing
Date: 2003-11-19 19:13:42
Message-ID: 200311192013.42574.barwick@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Wednesday 19 November 2003 17:35, Stephan Szabo wrote:
> On Wed, 19 Nov 2003, Ian Barwick wrote:
> > I have this table:
(...)
>
> You probably need to be querying like:
> WHERE substr(value,1,128)='foo';
> in order to use that index.
>
> While substr(txtcol, 1,128) happens to have the property that it would be
> probably be useful in a search against a short constant string, that's an
> internal property of that function.

That's the one :-). Thanks!

Ian Barwick
barwick(at)gmx(dot)net

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Ian Barwick 2003-11-19 19:16:48 Re: TEXT column and indexing
Previous Message Bruce Momjian 2003-11-19 18:58:27 Re: duration logging setting in 7.4