Skip site navigation (1) Skip section navigation (2)

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 (view raw, whole thread or download thread mbox)
Lists: pgsql-novice

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

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

Thanks in advance,


   (running 7.0.2).

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group