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

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: (view raw, whole thread or download thread mbox)
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

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

  Compiler used (example: gcc 2.8.0)            : gcc

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[]);
template1=> insert into a values ('{1,1,1,1,1,1,1}');
INSERT 27977 1
template1=> select * from a where
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:

pgsql-bugs by date

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

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