Received: from mail1.hub.org (webmail.hub.org [216.126.85.1]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f8HGTuX77052 for ; Mon, 17 Sep 2001 12:29:56 -0400 (EDT) (envelope-from news@news.tht.net) Received: from news.tht.net (news.hub.org [216.126.91.242]) by mail1.hub.org (8.11.3/8.11.4) with ESMTP id f8HG3Sj65371 for ; Mon, 17 Sep 2001 12:03:28 -0400 (EDT) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.4/8.11.4) id f8HFVQ869628 for pgsql-sql@postgresql.org; Mon, 17 Sep 2001 11:31:26 -0400 (EDT) (envelope-from news) From: rdear X-Newsgroups: comp.databases.postgresql.sql Subject: PL/PGSQL Regexe Date: Mon, 17 Sep 2001 16:41:22 +0100 Organization: Hub.Org Networking Services (http://www.hub.org) Lines: 10 Message-ID: <3BA619A2.6090402@dev.internal> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: scrappy@hub.org User-Agent: Mozilla/5.0 (X11; U; Linux 2.2.16-22 i686; en-US; m18) Gecko/20010131 Netscape6/6.01 X-Accept-Language: en To: pgsql-sql@postgresql.org X-Archive-Number: 200109/134 X-Sequence-Number: 4806 I'm doing a check within a PL/PGSQL function using a regular expression and I get the error: ERROR: regcomp failed with error invalid character range This appears to be because of the underscore "_" character. The regex I want to use is ''[A-Za-z0-9_]'' but this doesn't work. Any suggestions or is this a bug/feature?