Thread: Re: defining Your own sort order for already compiled PostgreSQL (because PSQL sort orders are incopatible with ASCII sort order for non -alpha characters)
Re: defining Your own sort order for already compiled PostgreSQL (because PSQL sort orders are incopatible with ASCII sort order for non -alpha characters)
From
"Hakan Kocaman"
Date:
jep 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: hakan.kocaman@digame.de > -----Original Message----- > From: pgsql-admin-owner@postgresql.org > [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Craig Servin > Sent: Tuesday, May 23, 2006 9:07 PM > To: pgsql-admin@postgresql.org > Subject: Re: [ADMIN] defining Your own sort order for already > compiled PostgreSQL (because PSQL sort orders are incopatible > with ASCII sort order for non -alpha characters) > > > 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: hakan.kocaman@digame.de > > ---------------------------(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 >