Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id AFDDB9FC0B3 for ; Fri, 20 Jul 2007 16:00:47 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 34323-03 for ; Fri, 20 Jul 2007 16:00:36 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from web56410.mail.re3.yahoo.com (web56410.mail.re3.yahoo.com [216.252.111.89]) by postgresql.org (Postfix) with SMTP id E9E2F9FA0CC for ; Fri, 20 Jul 2007 16:00:25 -0300 (ADT) Received: (qmail 46199 invoked by uid 60001); 20 Jul 2007 19:00:20 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=qGRWddHPRCtLXV+54rU7/8mlC17JDSqQOwoPhFj2YgdZhaozgJyCpeT/pPfcFdwdSxoiTNTnxcXzs5R6lvJmefHUgKDUvA8fgRmONZvsxP9zUtLnws3iyQAfKK4AdBqMQOdRp4TqWKKDnpha7QniPrQmoJ1Pdmji58V2e1zAgV4=; X-YMail-OSG: FhUiAj0VM1ljnFScv80_iViOgw4O2DJu6254F9led8xla_TGiKUHMT1gdl__lJKm4VrMZsCZumfgI0K5G_PP7Tz4WHDRMBM9Z395 Received: from [198.119.134.32] by web56410.mail.re3.yahoo.com via HTTP; Fri, 20 Jul 2007 12:00:18 PDT Date: Fri, 20 Jul 2007 12:00:18 -0700 (PDT) From: Jessica Richard Subject: select a range of data To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-124330305-1184958018=:11791" Content-Transfer-Encoding: 8bit Message-ID: <497741.11791.qm@web56410.mail.re3.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.225 tagged_above=0 required=5 tests=AWL=0.964, BAYES_20=-0.74, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200707/234 X-Sequence-Number: 26215 --0-124330305-1184958018=:11791 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit 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. --0-124330305-1184958018=:11791 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit 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. --0-124330305-1184958018=:11791--