Postgres Pro
Downloads
Home   >   mailing lists

regular expression - Mailing list pgsql-sql

From gurkan@resolution.com
Subject regular expression
Date
Msg-id 1128377310.4341abde55776@www.resolution.com
Whole thread Raw
Responses Re: regular expression  (Gnanavel S <s.gnanavel@gmail.com>)
Re: regular expression  (Michael Fuhr <mike@fuhr.org>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: andrew@pillette.com
Date:
Subject: MOVE in SQL vs PLPGSQL
Next
From: "Scott cox"
Date:
Subject: creating postgres tables by passing a string to function