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
---++
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
Manfred
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
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'
Try
... WHERE