Re: regular expression

Try this,
select substring('6768 - THY','[0-9]*');
substring
-----------
6768
(1 row)

On 10/4/05, gurkan(at)resolution(dot)com <gurkan(at)resolution(dot)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 <http://www.resolution.com>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>

--
with regards,
S.Gnanavel