Re: defining Your own sort order for already compiled PostgreSQL (because PSQL sort orders are incopatible with ASCII sort order for non -alpha characters)

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(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 Craig Servin
> Sent: Tuesday, May 23, 2006 9:07 PM
> To: pgsql-admin(at)postgresql(dot)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(dot)kocaman(at)digame(dot)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
>