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
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 |