Skip site navigation (1) Skip section navigation (2)

Re: select a range of data

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jessica Richard <rjessil(at)yahoo(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: select a range of data
Date: 2007-07-20 19:19:52
Message-ID: 12568.1184959192@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
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

In response to

pgsql-admin by date

Next:From: Michael MonnerieDate: 2007-07-20 20:07:10
Subject: Re: syslog: log line length?
Previous:From: Jon SimeDate: 2007-07-20 19:19:13
Subject: Re: select a range of data

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group