using regexp backreferences

[CSN]

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

[DeJuan Jackson]

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

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

[DeJuan Jackson]

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

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings