Received: from lyonnet.dtr.fr (lyonnet.dtr.fr [194.51.33.100]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fB3DbMm93631 for ; Mon, 3 Dec 2001 08:37:22 -0500 (EST) (envelope-from cvigny@artprice.com) Received: from artprice.com (groupe-serveur-14.43.242.194.in-addr.arpa [194.242.43.14]) by lyonnet.dtr.fr (8.8.5/8.8.5) with ESMTP id OAA19993 for ; Mon, 3 Dec 2001 14:37:04 +0100 Message-ID: <3C0B8012.215C8AC1@artprice.com> Date: Mon, 03 Dec 2001 14:37:22 +0100 From: Vigny Christophe X-Mailer: Mozilla 4.7 [fr] (WinNT; I) X-Accept-Language: fr MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: update with RE Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200112/72 X-Sequence-Number: 5895 hello, Is it possible to use a Regular expression to update a field like in perl (s/T/t/) ie : update table set name=($1) where name ~* '.*(phe).*' substitute using a grouping function $1 is in fact 'phe'. It should be really interesting and powerfull !