pgsql-bugs@postgresql.org writes:
> query 'SELECT '{1,2}' *= NULL' crash backend
The functions defined by the contrib/array module should all be marked
strict. But they were not in 7.2 :-(.
Current sources have, for example,
create or replace function array_texteq(_text, text) returns bool
as 'MODULE_PATHNAME'
language C with (isStrict);
in array_iterator.sql.in.
regards, tom lane