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/