That might be a problem that 'ó' is not recognized as \w
Actually I do not know which class 'ó' is in. It matches:
test=# select * from texts where title ~* E'\\mmacskacic\\M';
title | a_text
--------------+----------------------------
A macskacicó | A blah blah macskacicónak.
(1 row)
As if the end-of-word is at the last 'c' . ???
If the hex. code of 'ó' is 97 (dec.151) could someone hint me how to insert it into the expression?
On Tue, Jun 8, 2010 at 1:17 PM, Laslo Forro
<getforum@gmail.com> wrote:
Thanks a lot, anyway!On Tue, Jun 8, 2010 at 12:56 PM, Thom Brown
<thombrown@gmail.com> wrote:
On 8 June 2010 11:54, Laslo Forro <
getforum@gmail.com> wrote:
> test=# \l
> List of databases
> Name | Owner | Encoding | Collation | Ctype | Access
> privileges
> -----------+----------+----------+-------------+-------------+-----------------------
> postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
> template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres
> :
> postgres=CTc/postgres
> template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres
> :
> postgres=CTc/postgres
> test | salmonix | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
> (5 rows)
>
someone else can shed some light on it for you.
Thom
