Skip site navigation (1) Skip section navigation (2)

Re: [BUGS] problem with bool array

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: "Evgeny O(dot) Oleynikov" <evg(at)atom(dot)krasnet(dot)ru>
Cc: pgsql-bugs(at)postgreSQL(dot)org
Subject: Re: [BUGS] problem with bool array
Date: 1999-12-03 07:42:11
Message-ID: 199912030742.CAA07163@candle.pha.pa.us (view raw or flat)
Thread:
Lists: 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(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

In response to

pgsql-bugs by date

Next:From: Christof PetigDate: 1999-12-03 08:58:42
Subject: ECPG memory leak detected
Previous:From: Evgeny O. OleynikovDate: 1999-12-03 07:03:45
Subject: problem with bool array

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group