problem with bool array

From: "Evgeny O(dot) Oleynikov" <evg(at)atom(dot)krasnet(dot)ru>
To: pgsql-bugs(at)postgresql(dot)org
Subject: problem with bool array
Date: 1999-12-03 06:45:46
Message-ID: 3847671A.616F50@atom.krasnet.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================

Your name : Evgeny Oleynikov
Your email address : evg(at)atom(dot)krasnet(dot)ru

System Configuration
---------------------
Architecture (example: Intel Pentium) : Intel Pentium

Operating System (example: Linux 2.0.26 ELF) : FreeBSD 2.2.5-RELEASE
a.out

PostgreSQL version (example: PostgreSQL-6.5.3): PostgreSQL-6.4.2

Compiler used (example: gcc 2.8.0) : gcc 2.7.2.1

Please enter a FULL description of your problem:
------------------------------------------------
'bool' array return type 'char'

Please describe a way to repeat the problem. Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------

$ 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.
$

If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------
use:
a.wdays[int4(date_part('dow','now'::datetime))='t'

Browse pgsql-bugs by date

  From Date Subject
Next Message Evgeny O. Oleynikov 1999-12-03 07:03:45 problem with bool array
Previous Message Jason Cox 1999-12-01 17:33:26 problem with reading table feilds