agora inbox for postgres@postgres.berkeley.edu  

help / color / mirror / Atom feed

From: Aaron Roydhouse <Aaron.Roydhouse@Comp.VUW.AC.NZ>
To: postgres@postgres.Berkeley.EDU
Subject: Strange array_in behaviour
Date: Thu, 23 Jun 1994 14:26:53 +1200
Message-ID: <199406230226.OAA19534@downstage.comp.vuw.ac.nz> (raw)

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

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: postgres@postgres.berkeley.edu
  Cc: Aaron.Roydhouse@Comp.VUW.AC.NZ
  Subject: Re: Strange array_in behaviour
  In-Reply-To: <199406230226.OAA19534@downstage.comp.vuw.ac.nz>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox