On 18.04.2006, at 17:16 Uhr, Tarabas (Manuel Rorarius) wrote:
> Is there any way to speed the like's up with a different locale than C
> or to get an order by in a different Locale although using the
> default C locale?
Sure. Just create the index with
create index <tabname>_<column>_index on <tabname> (<column>
varchar_pattern_ops);
Than you can use something like
select * from <table> where <column> like 'Something%';
Remember that an index can't be used for queries with '%pattern%'.
cug