select substring('6768 - THY','[0-9]*');
substring
-----------
6768
(1 row)
On 10/4/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]
> 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
