pl/pgSQL: locale and ~ '[a-z]'

From: "Albert REINER" <areiner(at)tph(dot)tuwien(dot)ac(dot)at>
To: PostgreSQL-Novice <pgsql-novice(at)postgreSQL(dot)org>
Subject: pl/pgSQL: locale and ~ '[a-z]'
Date: 2001-05-01 19:07:06
Message-ID: 20010501210706.A229@frithjof
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Saluton,

I wonder - and have not found any documentation installed locally -
whether locale settings will influence pl/pgSQL's comparison via ~;
e.g. in my setting, ĉ, ĝ, ĥ etc. are all legal lower case characters -
will they be included in [a-z]? Or is the US locale assumed in those
comparisons?

And is this behavior permanent, so that one can rely on it for future
versions?

Thanks in advance,

Albert

(running 7.0.2).

Browse pgsql-novice by date

  From Date Subject
Next Message Patrice Espié 2001-05-02 08:08:51 Re: SELECT performance problem on a join
Previous Message J. Patrick Lanigan 2001-04-30 05:14:32 RE: Include and lib dirs under RH7?