Locale support for postgresql regex (src)

From: Antonello Nocchi <anto(at)cerca(dot)com>
To: pgsql-patches(at)postgresql(dot)org
Subject: Locale support for postgresql regex (src)
Date: 2002-01-13 01:34:57
Message-ID: 3C40E441.F05E5A03@cerca.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

Hi,

I modified two files in postgresql-7.1.3/src/backend/regex/ and in
postgresql-7.1.3/src/include/regex/
so 'character class' (eg. [[:alnum:]], [[:alpha:]], etc.) now should
support 'locale' settings.

http://galaxy.metacerca.it/~anto/pgslq_7_1_3_regex_locale.tar.gz (~14
KB, 2 files)

It is not a great work and do not support multibyte, but, for me, is
sufficient to isolate, for example, an italian word containing ascii
char > 127.
For example: select T from tab where T ~*
'(^|[^[:alnum:]]+)citt[[:alnum:]]*([^[:alnum:]]+|$)';
now match the word 'città' in a string like 'vado in città', 'città'
etc..

PS: excuse my poor english

Regards
Antonello

--
_______________________________________________________

Antonello Nocchi CERCA.COM S.r.l

Via dello Stadio, 19 Tel. +39-0578-75.77.77
53045 - Montepulciano (Siena) Tel. +39-0578-71.67.09
ITALY Fax. +39-0578-71.51.89
antonello(at)cerca(dot)com http://www.cerca.com

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Peter Eisentraut 2002-01-13 06:23:10 Re: pg_upgrade
Previous Message Greg Sabino Mullane 2002-01-12 22:09:42 Re: doc/src/FAQ/FAQ.html changes