Re: POSIX Regular Expression question

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: Harald Fuchs <hf0614x(at)protecting(dot)net>, pgsql-sql(at)postgresql(dot)org
Subject: Re: POSIX Regular Expression question
Date: 2005-09-05 17:31:44
Message-ID: 1897.1125941504@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> Am Montag, 5. September 2005 17:40 schrieb Harald Fuchs:
>> I dunno the details of the supported encodings, but is there
>> any encoding where 'a-z' includes more or less than 26 letters?

> Well, it seems that our regexp library interprets [a-z] as exactly 26 letters,
> but that seems to be a lack of locale support rather than a feature.

ISTM that the notation should properly mean "every character that sorts
between a and z inclusive". So it's sort order dependent and thus
locale dependent --- or at least should be. The locale support in our
regexp code is definitely pretty weak at the moment.

regards, tom lane

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Bath, David 2005-09-06 02:14:06 Equivalent of Oracle SQL%NOTFOUND in plpgsql
Previous Message Peter Eisentraut 2005-09-05 16:15:21 Re: POSIX Regular Expression question