Re: regular expression

[Please copy the mailing list on replies.]

On Wed, Oct 12, 2005 at 04:28:47PM -0400, gurkan(at)resolution(dot)com wrote:
> Thanks for the reply. It helped a lot. I was goint to ask similar question
> regarding regular expression, but this time I need not the numeric part. What I
> mean is;
> say that this may be in these format
> "TSWUU" ---need--- "TSWUU"
> "4 - DSC" ---need--- "DSC"
> "6768 - THY" ---need--- "THY"
> basically string may or may not start with number,
> I need substring of character if it starts with number discard it

This isn't a PostgreSQL issue, but rather one of understanding how
regular expressions work in general. See the previously mentioned
"Pattern Matching" section of the PostgreSQL documentation for the
PostgreSQL-specific details, and use a search engine to find a
regular expression tutorial; they're frequently used in Perl and
other languages so a lot of learning material exists. If you can
find a copy in a library or bookstore, the book _Mastering Regular
Expressions_ by Jeffrey E. F. Friedl, published by O'Reilly, is a
good resource.

--
Michael Fuhr