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:
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 > -----Original Message----- > From: pgsql-admin-owner@postgresql.org > [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Adam Radlowski > Sent: Tuesday, May 23, 2006 9:26 AM > To: pgsql-admin@postgresql.org > Subject: [ADMIN] defining Your own sort order for already > compiled PostgreSQL (because PSQL sort orders are incopatible > with ASCII sort order for non -alpha characters) > > > I can't find in the documentation, if it is possible to > define our own > sort order for already compiled PostgreSQL. > I need it, because the best for my now building application > were be to > build sort with normal LATIN2 sort order (for non alphanumeric chars > compatible with ASCII sort order). > I saw in the "configure" file, that it is possible to define, what is > alpha, what is number and so on, but it is inpossible to > administrators > of ready for use systems to - always recompile PostgreSQL for > only one > application. > With greetings > Adam > > ---------------------------(end of > broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org > so that your > message can get through to the mailing list cleanly >
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
Craig Servin
Date:
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