Re: regular expression
От
Gnanavel S
Тема
Re: regular expression
Дата
Msg-id
eec3b03c0510042156u3c45b280h9fcb01617ca693d6@mail.gmail.com
Ответ на
regular expression (gurkan@resolution.com)
Список
Дерево обсуждения
regular expression gurkan@resolution.com
Re: regular expression Michael Fuhr <mike@fuhr.org>
Re: regular expression Gnanavel S <s.gnanavel@gmail.com>
Try this,
select substring('6768 - THY','[0-9]*');
substring
-----------
6768
(1 row)
--
with regards,
S.Gnanavel
select substring('6768 - THY','[0-9]*');
substring
-----------
6768
(1 row)
On 10/4/05, gurkan@resolution.com <gurkan@resolution.com > wrote:
How do I do regular expression for the problem that I am having
I have a string called desc, and say that this string in
"TSWUU" ------ ""
"4 - DSC" ------ "4"
"6768 - THY" ------ "6768"
basically string may or may not start with number,
I need substring of digits parts
""
"4"
"6768"
-------------------------------------------------
This mail sent through IMP: www.resolution.com
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
--
with regards,
S.Gnanavel
В списке pgsql-sql по дате отправления
