Re: regular expression

On Mon, Oct 03, 2005 at 06:08:30PM -0400, 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"

See "Pattern Matching" in the documentation:

http://www.postgresql.org/docs/8.0/interactive/functions-matching.html

Example:

test=> SELECT id, data FROM foo;id |    data    
----+------------ 1 | TSWUU 2 | 4 - DSC 3 | 6768 - THY
(3 rows)

test=> SELECT id, substring(data FROM '^([[:digit:]]+)') FROM foo;id | substring 
----+----------- 1 |  2 | 4 3 | 6768
(3 rows)

-- 
Michael Fuhr