Postgres Pro
Downloads
Home   >   mailing lists

using regexp backreferences - Mailing list pgsql-general

From CSN
Subject using regexp backreferences
Date
Msg-id 20040608213208.5851.qmail@web52904.mail.yahoo.com
Whole thread Raw
Responses Re: using regexp backreferences
List pgsql-general
Tree view 
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/

pgsql-general by date:

Previous
From: jseymour@linxnet.com (Jim Seymour)
Date:
Subject: Re: Multiple databases on seperate drives/file systems?
Next
From: Richard Poole
Date:
Subject: Re: [SQL] simple addition of constraints problem