Re: Bug #779: query 'SELECT '{1,2}' *= NULL' crash backend - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Bug #779: query 'SELECT '{1,2}' *= NULL' crash backend
Date
Msg-id 22530.1032798830@sss.pgh.pa.us
Whole thread Raw
In response to Bug #779: query 'SELECT '{1,2}' *= NULL' crash backend  (pgsql-bugs@postgresql.org)
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: pgsql-bugs@postgresql.org
Date:
Subject: Bug #779: query 'SELECT '{1,2}' *= NULL' crash backend
Next
From: Ruslan A Dautkhanov
Date:
Subject: numeric type conversions