Обсуждение: Re: defining Your own sort order for already compiled PostgreSQL (because PSQL sort orders are incopatible with ASCII sort order for non -alpha characters)

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
>

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