"Josh Berkus" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
