Can you use backreferences in regular expressions like so? update table set title='foobar ' || \1 where title ~* '[a-z]+([0-9]+)';
__________________________________
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
