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(dot)kocaman(at)digame(dot)de

> -----Original Message-----
> From: pgsql-admin-owner(at)postgresql(dot)org
> [mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Adam Radlowski
> Sent: Tuesday, May 23, 2006 9:26 AM
> To: pgsql-admin(at)postgresql(dot)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(at)postgresql(dot)org
> so that your
> message can get through to the mailing list cleanly
>