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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026