Re: [BUGS] problem with bool array

> $ psql template1
> Welcome to the POSTGRESQL interactive sql monitor:
>   Please read the file COPYRIGHT for copyright terms of POSTGRESQL
>
>    type \? for help on slash commands
>    type \q to quit
>    type \g or terminate with semicolon to execute query
>  You are currently connected to the database: template1
>
> template1=> create table a (wdays bool[]);
> CREATE
> template1=> insert into a values ('{1,1,1,1,1,1,1}');
> INSERT 27977 1
> template1=> select * from a where
> a.wdays[int4(date_part('dow','now'::datetime))];
> pqReadData() -- backend closed the channel unexpectedly.
>         This probably means the backend terminated abnormally before or
> while processing the request.
> We have lost the connection to the backend, so further processing is
> impossible.  Terminating.

In current tree, it worked.  You may want to try 6.5.3:

test=> create table a (wdays bool[]);
CREATE
test=> insert into a values ('{1,1,1,1,1,1,1}');
INSERT 18889 1
test=>  select * from a where
tetime))];test-> a.wdays[int4(date_part('dow','now'::datetime))];
      wdays
-----------------
 {t,t,t,t,t,t,t}
(1 row)

test=>

--
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026