Postgres Pro
Downloads
Home   >   mailing lists

select a range of data - Mailing list pgsql-admin

From Jessica Richard
Subject select a range of data
Date
Msg-id 497741.11791.qm@web56410.mail.re3.yahoo.com
Whole thread Raw
Responses Re: select a range of data  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: select a range of data  (Jon Sime <jsime@mediamatters.org>)
List pgsql-admin
Tree view
If I have a column with a value like "abc2457", "efg1234",

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?

Thanks.

Boardwalk for $500? In 2007? Ha!
Play Monopoly Here and Now (it's updated for today's economy) at Yahoo! Games.

pgsql-admin by date:

Previous
From: "Sibte Abbas"
Date:
Subject: Re: row level locking
Next
From: Tom Lane
Date:
Subject: Re: select a range of data