Received: from home.grafton.lv (home.grafton.lv [159.148.106.93]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f3Q9qn345873 for ; Thu, 26 Apr 2001 05:52:50 -0400 (EDT) (envelope-from emils@grafton.lv) Received: from mortyr (mortyr.grafton.lv [159.148.106.65]) by home.grafton.lv (8.9.3/8.8.7) with ESMTP id MAA18309 for ; Thu, 26 Apr 2001 12:52:48 +0300 From: "Emils Klotins" Organization: Grafton Entertainment To: pgsql-sql@postgresql.org Date: Thu, 26 Apr 2001 12:54:19 +0200 MIME-Version: 1.0 Content-type: text/plain; charset=ISO-8859-1 Subject: Regexps -- too complex? Message-ID: <3AE81A7B.2506.E8EB40C@localhost> X-mailer: Pegasus Mail for Win32 (v3.12c) Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from Quoted-printable to 8bit by postgresql.org id f3Q9qo345882 X-Archive-Number: 200104/396 X-Sequence-Number: 2754 Running 7.0.2 on Alpha/RedHat 6.2 256MB RAM In order to implement a fulltext search, I have a func that parses list of words and creates a regexp query with things like [[:<:]]( word | word | ... )[[:>:]] That query then is passed to backend... Now the strange thing: gamenet=# SELECT id, title,publishdate,categoryid FROM articles WHERE translate(title,'abcdefghijklmnopqrstuvwxyzâèçìîíïòðûþõäöü','ABCDEFGHIJKLMNOPQRSTUVWXYZÂÈÇÌÎÍÏÒÐÛÞÕÄÖÜ') ~ '(BLACK|SERIOUS|SAM)[[:>:]]'::text ; id | title | publishdate | categoryid ------+-------------------------------------------------+-------------+------------ 600 | Serious Sam ceïâ pie pircçjiem | 2001-03-22 | 149 523 | Black & White gaidîðanas svçtki | 2001-03-19 | 155 241 | Lorgaine: The Black Standard - íeltu varoòeposs | 2001-02-27 | 155 707 | Lorgaine: The Black Standard beta versija | 2001-03-23 | 156 1484 | Black&White tomçr neesot spiegu programma | 2001-04-18 | 155 1490 | Black & White FAQ | 2001-04-18 | 160 1496 | Black & White "ïaunais" FAQ | 2001-04-18 | 160 1732 | Black & White - pârdotâkâ spçle ASV | 2001-04-24 | 155 (8 rows) gamenet=# SELECT id, title,publishdate,categoryid FROM articles WHERE translate(title,'abcdefghijklmnopqrstuvwxyzâèçìîíïòðûþõäöü','ABCDEFGHIJKLMNOPQRSTUVWXYZÂÈÇÌÎÍÏÒÐÛÞÕÄÖÜ') ~ '(BLACK|SERIOUS|WHITE|SAM)[[:>:]]'::text ; id | title | publishdate | categoryid ----+-------+-------------+------------ (0 rows) It seems that if the regexp is too complex (more than 3 |-ed elements) it doesnt return. Any ideas?