> There is obviously a problem with the scecial characters.
> The query SELECT 'oneå two three' ~ '^[^ ]+[ ][^ ]+$';
> produced FALSE on a database with ENCODING = 'LATIN1' and TRUE on a database
> with ENCODING = 'UNICODE'.
>
> Do you have a suggestion to how I can find the count of two-word strings
> with ENCODING = 'UNICODE'?
I see no problem here.
SELECT 'oneå two three' ~ '^[^ ]+[ ][^ ]+$';?column?
----------f
(1 row)
SELECT 'oneå three' ~ '^[^ ]+[ ][^ ]+$';?column?
----------t
(1 row)
(The database encoding is UNICODE)
This is PostgreSQL 7.1.3/7.2.1 running on a Linux box. I guess you
have some problems with your installation or platform.
--
Tatsuo Ishii