regular expression

From: gurkan(at)resolution(dot)com
To: pgsql-sql(at)postgresql(dot)org
Cc: gurkan(at)resolution(dot)com
Subject: regular expression
Date: 2005-10-03 22:08:30
Message-ID: 1128377310.4341abde55776@www.resolution.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message jan aerts (RI) 2005-10-04 08:27:56 Re: combination of function to simple query makes query slow
Previous Message andrew 2005-10-03 20:57:15 MOVE in SQL vs PLPGSQL