Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 8CDB49FA030 for ; Tue, 2 Oct 2007 17:30:11 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 68727-06 for ; Tue, 2 Oct 2007 17:30:05 -0300 (ADT) X-Greylist: delayed 00:06:11.657798 by SQLgrey-1.7.5 Received: from s15216962.onlinehome-server.info (s15216962.onlinehome-server.info [217.160.22.205]) by postgresql.org (Postfix) with ESMTP id F400A9FA02F for ; Tue, 2 Oct 2007 17:30:05 -0300 (ADT) Received: (from uucp@localhost) by s15216962.onlinehome-server.info (8.13.3/8.13.3) with UUCP id l92KNmvc019578 for pgsql-sql@postgresql.org; Tue, 2 Oct 2007 22:23:48 +0200 Received: (from weigelt@localhost) by nibiru.metux.de (8.12.10/8.12.10) id l92KNEWS030320 for pgsql-sql@postgresql.org; Tue, 2 Oct 2007 22:23:15 +0200 Date: Tue, 2 Oct 2007 22:23:14 +0200 From: Enrico Weigelt To: pgsql-sql Subject: Finding broken regex'es Message-ID: <20071002202313.GB18506@nibiru.local> Reply-To: weigelt@metux.de Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.4.1i X-Terror: bin laden, kill bush, Briefbombe, Massenvernichtung, KZ, X-Nazi: Weisse Rasse, Hitlers Wiederauferstehung, 42, X-Antichrist: weg mit schaeuble, ausrotten, heiliger krieg, al quaida, X-Killer: 23, endloesung, Weltuntergang, X-Doof: wer das liest ist doof X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/5 X-Sequence-Number: 29377 Hi folks, I'm looking for some way to find broken regex'es in some column to kick them off. For now I'm regularily fetching all regexes from an PHP script, try an preg_match() and so find the broken ones to later remove them. Is there any way to do this directly within the db ? thx -- --------------------------------------------------------------------- Enrico Weigelt == metux IT service - http://www.metux.de/ --------------------------------------------------------------------- Please visit the OpenSource QM Taskforce: http://wiki.metux.de/public/OpenSource_QM_Taskforce Patches / Fixes for a lot dozens of packages in dozens of versions: http://patches.metux.de/ ---------------------------------------------------------------------