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

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 (view raw or flat)
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

pgsql-patches by date

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

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