> SELECT id, title,publishdate,categoryid FROM articles WHERE
> upper(title) ~ '(BLACK|SERIOUS|SAM)[[:>:]]'::text ;
>
> I think the proiblem is in trnsalte, not in regexp
>
> If you have installed apprporiate character encoding in Postgres,
> 'upper' will work!
>
> Vladimir
Thanks for the advice, unfortunately, it does not seem to work that
way.
CREATE TABLE "test" (
"title" text
);
COPY "test" FROM stdin;
Serious Sam ceļā pie pircējiem
Black & White gaidīšanas svētki
Lorgaine: The Black Standard - ķeltu varoņeposs
Lorgaine: The Black Standard beta versija
Black&White tomēr neesot spiegu programma
Black & White FAQ
Black & White "ļaunais" FAQ
Black & White - pārdotākā spēle ASV
\.
SELECT title FROM test WHERE title ~ '(BLACK|WHITE|SAM)';
yields 8 rows.
SELECT title FROM test WHERE title ~
'(BLACK|WHITE|blahblah|SAM)';
yields 0 rows!
SELECT title FROM test WHERE title ~ '(BLACK|WHITE|SAM) *';
also yields 0 rows!
I dont think this is right no matter what the characters I am using
there. At least it shouldn't, should it?
Emils
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
