Received: from sss.pgh.pa.us (sss.pgh.pa.us [209.114.132.154]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f2J4MN671880 for ; Sun, 18 Mar 2001 23:22:23 -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 f2J4MLt08900; Sun, 18 Mar 2001 23:22:21 -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: Sun, 18 Mar 2001 23:22:21 -0500 Message-ID: <8897.984975741@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200103/350 X-Sequence-Number: 2014 "Josh Berkus" writes: > Er, Tom, I'm using 7.1. > Pgsql does return a null as expected when going from the command line. > However, if I call the regular expression from within a PL/pgSQL > function, it bombs. Well, that's more interesting, but I still can't reproduce it ... regression=# \df+ test1 List of functions Result | Function | Arguments | Owner | Language | Source | Description ---------+----------+-----------+----------+----------+------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------+------------ - integer | test1 | | postgres | plpgsql | declare expression1 VARCHAR; return_value INT4; BEGIN expression1 := NULL; SELECT id INTO return_value FROM table1 WHERE field2 ~* expression1; RETURN return_value; END; | (1 row) regression=# create table table1 (id int, field2 text); CREATE regression=# select test1(); test1 ------- (1 row) regression=# insert into table1 values(1,'zz'); INSERT 1273361 1 regression=# select test1(); test1 ------- (1 row) regression=# insert into table1 values(1,null); INSERT 1273362 1 regression=# select test1(); test1 ------- (1 row) regards, tom lane