Jessica Richard <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
