On Wednesday 19 November 2003 17:26, you wrote:
> On Wed, 19 Nov 2003 10:18:18 +0100, Ian Barwick <[EMAIL PROTECTED]>
>
> wrote:
> >Indexes:
> >[...]
> >"opv_v_ix" btree (substr(value, 1, 128))
> >
> >SELECT obj_property_id
> > FROM object_property_value opv
> > WHERE opv.value = 'foo'
>
>
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 t
On Wed, 19 Nov 2003 10:18:18 +0100, Ian Barwick <[EMAIL PROTECTED]>
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
M
On Wed, 19 Nov 2003, Ian Barwick wrote:
>
> I have this table:
>
> db=> \d object_property_value
>Table "db.object_property_value"
> Column | Type | Modifiers
> ---++
I have this table:
db=> \d object_property_value
Table "db.object_property_value"
Column | Type | Modifiers
---++
obj_prop
