Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 781C4133798E for ; Tue, 18 Jan 2011 19:55:45 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 80094-05 for ; Tue, 18 Jan 2011 23:55:39 +0000 (UTC) Received: from news.hub.org (news.hub.org [200.46.204.72]) by mail.postgresql.org (Postfix) with ESMTP id 616D2133655C for ; Tue, 18 Jan 2011 19:55:38 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.14.4/8.14.4) with ESMTP id p0INtclp036783 for ; Tue, 18 Jan 2011 19:55:38 -0400 (AST) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.14.4/8.14.4/Submit) id p0INfS7U007835 for pgsql-sql@postgresql.org; Tue, 18 Jan 2011 19:41:28 -0400 (AST) (envelope-from news) From: andrew1 X-Newsgroups: pgsql.sql Subject: question about reg. expression Date: Tue, 18 Jan 2011 18:41:20 -0500 Organization: Aioe.org NNTP Server Lines: 10 Message-ID: Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: abuse@aioe.org X-Notice: Filtered by postfilter v. 0.8.2 User-Agent: Mozilla-Thunderbird 2.0.0.24 (X11/20100328) To: pgsql-sql@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.79 tagged_above=-5 required=5 tests=BAYES_50=0.8, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201101/50 X-Sequence-Number: 34997 hi all, these return t: select 'ab' ~ '[a-z]$' select 'ab' ~ '^[a-z]' select 'ab' ~ '^[a-z]$' returns f Can't I use ^ and $ at the same time to match, in this case? thanks.