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:
regards, tom lane
In response to
pgsql-admin by date
|Next:||From: Michael Monnerie||Date: 2007-07-20 20:07:10|
|Subject: Re: syslog: log line length?|
|Previous:||From: Jon Sime||Date: 2007-07-20 19:19:13|
|Subject: Re: select a range of data|