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
>