Return-Path: aoki
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA22927; Tue, 19 Jan 93 14:07:09 -0800
Message-Id: <9301192207.AA22927@postgres.Berkeley.EDU>
From: <aoki@postgres.berkeley.edu>
Subject: Re: < ``arrays of arrays'' >
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu
In-Reply-To: Your message of Tue, 19 Jan 1993 21:01:04 +0100 (MET) 
	     <9301191958.AA21929@postgres.Berkeley.EDU> 
Date: Tue, 19 Jan 93 14:05:07 PST

> is the following behavior concerning the entry 'Susi' correct ?
> append bla (name="Susi", telno = "{ "1191" }"      ) \g
> ---------------------------------------------
> | Susi        | {}            | (null)      |
> ---------------------------------------------

No.  This is a bug in the array code.  The code that parses array strings
first counts values in such a way that it can never count exactly one value.
Hence, you can never have an array constant with exactly one value.

This has been fixed in 4.1 (which will be out Any Day Now).  However, you
*have* to quote a single value (or the parser can't tell the difference
between a blank text string and a null array).  An artifact of the syntax..
--
  Paul M. Aoki  |  CS Div., Dept. of EECS, UCB  |  aoki@postgres.Berkeley.EDU
                |  Berkeley, CA 94720           |  ...!uunet!ucbvax!aoki