Thread: using regexp backreferences

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/

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]+)';
>
>
>
>
>
>
>__________________________________
>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
>
>