Re: Pattern Matching - Range of Letters

Thanks Richard and Joshua, I had no idea that BETWEEN worked for text.

SELECT *
FROM Your_table AS YT
WHERE YT.text_field BETWEEN 'Aa' AND 'An';

postgres=# select * from test where test between 'A' and 'An';
test
------
A
Ab
Ac
(3 rows)

Ron

Ron St-Pierre wrote:
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>