Re: select a range of data

Jessica Richard <rjessil(at)yahoo(dot)com> writes:
> how do I select col from table where col like 'a[a-z]c24[0-9]7"?
> How do I handle the range bracket in the query?

Using LIKE, you don't. However there are two other types of
pattern-matching operators that do understand character classes:

http://www.postgresql.org/docs/8.2/static/functions-matching.html

regards, tom lane