Re: [BUGS] problem with bool array
От | Bruce Momjian |
---|---|
Тема | Re: [BUGS] problem with bool array |
Дата | |
Msg-id | 199912030742.CAA07163@candle.pha.pa.us обсуждение исходный текст |
Ответ на | problem with bool array ("Evgeny O. Oleynikov" <evg@atom.krasnet.ru>) |
Список | pgsql-bugs |
> $ 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
В списке pgsql-bugs по дате отправления: