Date: Wed, 12 Oct 2005 15:03:37 -0600
From: Michael Fuhr <mike@fuhr.org>
To: gurkan@resolution.com
Cc: pgsql-sql@postgresql.org
Subject: Re: regular expression
Message-ID: <20051012210337.GA50999@winnie.fuhr.org>
Reply-To: pgsql-sql@postgresql.org
References: <1129148927.434d71ffc0e13@www.resolution.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <1129148927.434d71ffc0e13@www.resolution.com>

[Please copy the mailing list on replies.]

On Wed, Oct 12, 2005 at 04:28:47PM -0400, gurkan@resolution.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