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