Received: from sss.pgh.pa.us (sss.pgh.pa.us [209.114.132.154]) by mail.postgresql.org (8.11.3/8.11.1) with ESMTP id f2JHkeN27834 for ; Mon, 19 Mar 2001 12:46:40 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.1/8.11.1) with ESMTP id f2JHkdt20344; Mon, 19 Mar 2001 12:46:39 -0500 (EST) To: "Josh Berkus" cc: pgsql-sql@postgresql.org Subject: Re: What do I do with this error? In-reply-to: References: Comments: In-reply-to "Josh Berkus" message dated "Sun, 18 Mar 2001 20:09:59 -0800" Date: Mon, 19 Mar 2001 12:46:39 -0500 Message-ID: <20341.985023999@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200103/364 X-Sequence-Number: 2028 BTW, are you certain that your failure case actually does involve a NULL, and not an empty string? regression=# select 'foo' ~* null; ?column? ---------- (1 row) regression=# select 'foo' ~* ''; ERROR: regcomp failed with error empty (sub)expression This is correct according to the POSIX definition of regular expressions ("A (modern) RE is one or more non-empty branches ..."). regards, tom lane