Perhaps helps:
'ó' matches
\M
\M\M\M
\.*
but not \M\M\M\M or \M\M\M\W
These match:
E'\\mmacskacicó\M*'
E'\\mmacskacicó\s*'
E'\\mmacskacicó\W*'
with * quantifier. But not with + quantifier, or w/o any quantifier.
Also matches:
E'\\mmacskacicó\\Y' (!!!)
E'\\mmacskacicó$'
The text is typed via psql using urxvt terminal.
Perhaps some unicode - wide charater kind of mess?
On Tue, Jun 8, 2010 at 1:26 PM, Laslo Forro
<getforum@gmail.com> wrote:
That might be a problem that 'ó' is not recognized as \wActually 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)
>
Okay, I'm not sure what the problem is there then. :S Hopefully
someone else can shed some light on it for you.
Thom