Received: from shaked.cc.openu.ac.il (shaked.cc.openu.ac.il [147.233.145.65]) by hub.org (8.8.8/8.7.5) with ESMTP id EAA08384 for ; Sun, 7 Jun 1998 04:25:56 -0400 (EDT) Received: from [147.233.159.109] (herouth@mac-herouth.pc.openu.ac.il [147.233.159.109]) by shaked.cc.openu.ac.il (8.8.5/8.8.5) with ESMTP id LAA18518; Sun, 7 Jun 1998 11:25:08 +0300 (IDT) X-Sender: herouth@shaked.cc.openu.ac.il Message-Id: In-Reply-To: <357655DB.4905@nctech.fr> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Date: Sun, 7 Jun 1998 11:26:28 +0300 To: Stephane MONEGER , pgsql-sql@postgreSQL.org From: Herouth Maoz Subject: Re: [SQL] Problem with array of char At 11:07 +0300 on 4/6/98, Stephane MONEGER wrote: > Do you have an idea? A solution? I have very large tables and char[][] > is the only way I found to save values of 1 byte (as thin int are not > supported by PostgreSQL). I'm not sure if it's any help, but PostgreSQL has a built-in type called "bytea", which is a variable-length array of bytes. Maybe you should play around with it. I'm not sure how values are inserted to it - it seems to behave very much like the text type. Herouth -- Herouth Maoz, Internet developer. Open University of Israel - Telem project http://telem.openu.ac.il/~herutma