From: Vigny Christophe <cvigny@artprice.com>
To: pgsql-sql@postgresql.org
Subject: update with RE
Date: Mon, 03 Dec 2001 14:37:22 +0100
Message-ID: <3C0B8012.215C8AC1@artprice.com> (raw)
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 !
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: cvigny@artprice.com
Subject: Re: update with RE
In-Reply-To: <3C0B8012.215C8AC1@artprice.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox