normally you shouldn't have to do anything, it should just work :
select field from table where field like 'abc%'
CREATE INDEX ... ON table( field );
that's all
If it does not use the index, I saw on the mailing list that the locale
could be an issue.
Stephan Szabo wrote:
You can also create an index using a typename_pattern_ops operator
class which should be usable even with other collations.
Could you give me an example for this, or point me to the relevant
documentation?
---(end of
On Mon, 14 Feb 2005, Ivan Voras wrote:
Stephan Szabo wrote:
You can also create an index using a typename_pattern_ops operator
class which should be usable even with other collations.
Could you give me an example for this, or point me to the relevant
documentation?
Basically, you could