update with RE

From: Vigny Christophe <cvigny(at)artprice(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: update with RE
Date: 2001-12-03 13:37:22
Message-ID: 3C0B8012.215C8AC1@artprice.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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 !

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Stephan Szabo 2001-12-03 19:07:19 Re: persistent connections, AOLserver (Was: maybe Offtopic :
Previous Message Tapan Trivedi 2001-12-03 12:04:51 Inline IF condition