Can you clarify this for me? Does this mean that if we are using UTF-8 as the encoding a like clause will not use the index unless we specify varchar_pattern_ops as the index operator class?
Craig On Tuesday 23 May 2006 03:14, Hakan Kocaman wrote: > Hi, > > i think this explains, what you ment: > http://www.linuxshare.ru/postgresql/manual/creating-cluster.html > http://www.linuxshare.ru/postgresql/manual/charset.html#LOCALE > > So you don't need to set the Locale-Settings on compile-time, > but on initdb-time. > > Also check if this applies to your kinds of query, because with > a non-C Locale you need to define the indices with a different operator- > class to use the indices with like-comparisons. > See > http://www.postgresql.org/docs/8.1/static/indexes-opclass.html > for more details. > > Best regards > > Hakan Kocaman > Software-Development > > digame.de GmbH > Richard-Byrd-Str. 4-8 > 50829 Köln > > Tel.: +49 (0) 221 59 68 88 31 > Fax: +49 (0) 221 59 68 88 98 > Email: [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
