Pattern Matching - Range of Letters

From: Ron St-Pierre <ron(dot)pgsql(at)shaw(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Pattern Matching - Range of Letters
Date: 2007-05-10 19:23:11
Message-ID: 4643711F.3060409@shaw.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm sure that others have solved this but I can't find anything with my
(google and archive) searches. I need to retrieve data where the text
field is within a certain range e.g.
A-An
Am-Bc
Bc-Eg
....
Yi-Zz

Does anyone know of a good approach to achieve this? Should I be looking
into regular expressions, or maybe converting them to their ascii value
first?

Any comments are appreciated.

postgres 8.2.4, RHEL

Thanks
Ron St.Pierre

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Broersma Jr 2007-05-10 19:33:49 Re: Pattern Matching - Range of Letters
Previous Message Tom Lane 2007-05-10 19:21:43 Re: Views- Advantages and Disadvantages