Return-Path: owner-postman
Received: from localhost (localhost [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id TAA24821 for postgres-redist; Wed, 22 Jun 1994 19:27:10 -0700
Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199406230227.TAA24821@nobozo.CS.Berkeley.EDU>
X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost didn't use HELO protocol
Sender: owner-postman@postgres.Berkeley.EDU
X-Return-Path: owner-postman
Received: from kaukau.comp.vuw.ac.nz (kaukau.comp.vuw.ac.nz [130.195.5.20]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with ESMTP id TAA24811 for <postgres@nobozo.CS.Berkeley.EDU>; Wed, 22 Jun 1994 19:27:06 -0700
Received: from downstage.comp.vuw.ac.nz (downstage.comp.vuw.ac.nz [130.195.6.10]) by kaukau.comp.vuw.ac.nz (8.6.9/8.6.9-VUW)
	 with ESMTP id OAA20669 for <postgres@nobozo.CS.Berkeley.EDU>; Thu, 23 Jun 1994 14:26:39 +1200
From: Aaron Roydhouse <Aaron.Roydhouse@Comp.VUW.AC.NZ>
Received: from localhost (aaron@localhost) by downstage.comp.vuw.ac.nz (8.6.9/8.6.6) with SMTP id OAA19534 for <postgres@nobozo.CS.Berkeley.EDU>; Thu, 23 Jun 1994 14:26:54 +1200
Message-Id: <199406230226.OAA19534@downstage.comp.vuw.ac.nz>
To: postgres@postgres.Berkeley.EDU
Subject: Strange array_in behaviour
Date: Thu, 23 Jun 1994 14:26:53 +1200
Resent-To: postgres-redist@postgres.Berkeley.EDU
Resent-Date: Wed, 22 Jun 94 19:27:10 -0700
Resent-XMts: smtp

The array_in proceeds frequently rejects seemingly valid
multidimensional array string constants, consider the attached
example. Can anyone explain this behaviour? It would be quite painful
if I have to make all sub-arrays of equal size in string constants.

On a related note, what are the storage requirements of
multidimensional arrays? Just the number of elements appended, or the
product of the maximum size in each dimension?

Perhaps I would be better advised to use a bunch of single dimensional
arrays?

Aaron.
----------------------------------------------------------------------
* create foo (list = oid[][])\g

Query sent to backend is "create foo (list = oid[][])"
CREATE
Go 
* append foo (list = "{{1,2,3,4,5},{1,2,3,4,5}}")\g

Query sent to backend is "append foo (list = "{{1,2,3,4,5},{1,2,3,4,5}}")"
APPEND 50418
Go 
* append foo (list = "{{1,2,3,4,5},{1,2,3,4}}")\g

Query sent to backend is "append foo (list = "{{1,2,3,4,5},{1,2,3,4}}")"
APPEND 50419
Go 
* append foo (list = "{{1,2,3,4,5},{1,2,3}}")\g

Query sent to backend is "append foo (list = "{{1,2,3,4,5},{1,2,3}}")"
APPEND 50420
Go 
* append foo (list = "{{1,2,3,4,5},{1,2}}")\g

Query sent to backend is "append foo (list = "{{1,2,3,4,5},{1,2}}")"
WARN:Jun 23 02:17:43:array_in: illformed array constant

Go 
* append foo (list = "{{1,2,3,4,5},{1}}"\g

Query sent to backend is "append foo (list = "{{1,2,3,4,5},{1}}""
WARN:Jun 23 02:17:51:array_in: illformed array constant

Go 
* append foo (list = "{{1,2,3,4,5},{}}"\g

Query sent to backend is "append foo (list = "{{1,2,3,4,5},{}}""
WARN:Jun 23 02:18:06:array_in: illformed array constant

Go 
* append foo (list = "{{1,2,3,4,5}}")\g

Query sent to backend is "append foo (list = "{{1,2,3,4,5}}")"
APPEND 50421
Go 
* 

==============================================================================
   To add/remove yourself to/from the POSTGRES mailing list: send mail with 
   the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU"

   If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
   a human will deal with it.  DO NOT post to the "postgres" mailing list.
==============================================================================