Alvaro Herrera <alvhe...@alvh.no-ip.org> writes: > Determining that an array has a NULL element seems convoluted. I ended > up with this query, where comparing the result of array_positions() with > an empty array does that. If anybody knows of a simpler way, or any > situations in which this fails, I'm all ears.
Maybe better to rethink why we allow elements of prattrs to be null? regards, tom lane