Re: Best way to use indexes for partial match at beginning

["Andrus" <eetasoft@xxxxxxxxx>]

> you can create two indexes:
>
> CREATE INDEX myindex_lc on mytable(col1 text_pattern_ops);
> and
> CREATE INDEX myindex_normal ON foo(col1);
>
> the first one will be used when using LIKE and the other for normal
> comparisons .

Jaime,

CREATE INDEX myindex_normal ON foo(col1);

Creates btree structure. In other dbm system btree structure can be used for 
searches where only some first characters in index key are known.

So I see no reason to create second index using text_pattern_ops for this 
purpose.

I'm searching a way to use Postgres regular index for this.

Andrus. 



---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq