Tom,
> Yes, I'd say so. 7.1 returns a NULL as expected ...
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.
Therefore, please forward to pgsql-bugs:
Bug Name: Regular Expressions with NULL error out in PL/pgSQL.
Can Reproduce: Reliably
Severity: Annoyance.
Location: PL/pgSQL / Function handler / SPI
Version: 7.1 beta 3
Description: If you attempt to run a query within a PL/pgSQL function
which compares a field. via regular expression, to a NULL variable, you
get a fatal error.
Example:
CREATE FUNCTION test1 () RETURNS INT4 AS
'DELCARE expression1 VARCHAR;return_value INT4;
BEGINexpression1 := NULL;SELECT id INTO return_valueFROM table1WHERE field2 ~* expression1;RETURN return_value;
END;
-Josh
______AGLIO DATABASE SOLUTIONS___________________________ Josh Berkus Complete
informationtechnology josh@agliodbs.com and data management solutions (415) 565-7293 for law firms, small
businesses fax 621-2533 and non-profit organizations. San Francisco