No you cannot.
But look at this for a pointer:
select 'hi' || (select substring('hello1234567890' from '[0-9]+$'))
where 'hello1234567890' ~* '[a-z]+([0-9+])';
CSN wrote:
Can you use backreferences in regular expressions like
so?
update table set title='foobar ' || \1 where title ~*
'[a-z]+([0-9]+)
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/
---
