From: | DeJuan Jackson <djackson(at)speedfc(dot)com> |
---|---|
To: | CSN <cool_screen_name90001(at)yahoo(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: using regexp backreferences |
Date: | 2004-06-08 23:19:19 |
Message-ID: | 40C64977.6090000@speedfc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2004-06-08 23:48:44 | Re: OS X & thread safety |
Previous Message | Stephan Szabo | 2004-06-08 23:18:07 | Re: simple addition of constraints problem |