Received: from NCTech.FR (nctech.nctech.fr [194.51.102.100]) by hub.org (8.8.8/8.7.5) with SMTP id EAA25871 for ; Thu, 4 Jun 1998 04:10:01 -0400 (EDT) Received: from emeraude.nctech.fr by NCTech.FR (SMI-8.6/SMI-SVR4) id KAA26655; Thu, 4 Jun 1998 10:04:01 +0200 Received: from emeraude by emeraude.nctech.fr (SMI-8.6/SMI-SVR4) id KAA18627; Thu, 4 Jun 1998 10:07:55 +0200 Sender: moneger@NCTech.FR Message-ID: <357655DB.4905@nctech.fr> Date: Thu, 04 Jun 1998 10:07:55 +0200 From: Stephane MONEGER Organization: NCTech X-Mailer: Mozilla 3.0 (X11; I; SunOS 5.5.1 sun4m) MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Problem with array of char Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Hi! I have a serious problem with PostgreSQL 6.3 concerning array of char... I can create table with array of char2 for exemple, but not array of char. create table tab1(a char2[][]); -> OK create table tab2(a int2[][]); -> OK create table tab3(a char[][]); -> error... I can't find it as a known bug and this functionality was possible with previous version of Postgresql. 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). Thanks! Stephane -- ________________________________________________________________________ Network Computing Technologies Stéphane MONEGER Information System Designer Marimba Certified Consultant NCTech Phone : +33 4 78 61 46 29 8, rue Hermann Frenkel Fax : +33 4 78 61 46 99 69007 LYON Cedex FRANCE Email : smoneger@nctech.fr ________________________________________________________________________