Re: defining Your own sort order for already compiled PostgreSQL (because PSQL sort orders are incop

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=20
> [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=20
> compiled PostgreSQL (because PSQL sort orders are incopatible=20
> with ASCII sort order for non -alpha characters)
>=20
>=20
> Can you clarify this for me? Does this mean that if we are=20
> using UTF-8 as the=20
> encoding a like clause will not use the index unless we specify=20
> varchar_pattern_ops as the index operator class?
>=20
> Craig
>=20
>=20
> 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#LOCA LE
> >
> > 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=20
> different operator-
> > class to use the indices with like-comparisons.
> > See
> > http://www.postgresql.org/docs/8.1/static/indexes-opclass.ht ml
> > 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
>=20
> ---------------------------(end of=20
> 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
>=20

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org