"Vladimir" <[EMAIL PROTECTED]> writes:
> create table tst (a int[]);
> insert into tst values ('{1}'); -- (1)
> insert into tst values (null);
> insert into tst values ('{2}'); -- (3)
> select z.a from tst z where exists (select 1 from
> (
> select generate_series(1,1) as s,* from (select z.a as arr0) qq
> ) q
> where (q.arr0[q.s] is null) );
Hmm, surprising this hasn't been found before, because the underlying
bug has been around for a long time :-(. Fix committed --- thanks for
the report!
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
