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

On Wed, 19 Nov 2003 10:18:18 +0100, Ian Barwick <barwick@gmx.net>
wrote:
>Indexes:
>    [...]
>    "opv_v_ix" btree (substr(value, 1, 128))

>SELECT obj_property_id
>  FROM object_property_value opv
> WHERE opv.value = 'foo'

Try
    ... WHERE substr(opv.value, 1, 128) = 'foo'

HTH.
Servus
 Manfred