Re: TEXT column and indexing - Mailing list pgsql-performance

From Ian Barwick
Subject Re: TEXT column and indexing
Date
Msg-id 200311192013.42574.barwick@gmx.net
Whole thread Raw
In response to Re: TEXT column and indexing  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
List 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@gmx.net


pgsql-performance by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: duration logging setting in 7.4
Next
From: Ian Barwick
Date:
Subject: Re: TEXT column and indexing