Return-Path: pg_adm@postgres.berkeley.edu
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA00064; Fri, 18 Jun 93 09:08:54 -0700
Date: Fri, 18 Jun 93 09:08:54 -0700
Message-Id: <9306181608.AA00064@postgres.Berkeley.EDU>
From: ruby!imram@colossus.apple.com (Steve Davidson)
Subject: Bug: Append with single array value
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu

Dear Postgressors,

An append with a single array value fails where multiple values
succeed.  It looks like a bug in the parser.  Here's the code:

In all cases the Query is:
retrieve (e.all) from e in TEST


create TEST (numbers=int4[], strings=text[])
append TEST (numbers="{1, 2, 3, 4}", strings="{aaa, bbb}")
---works
 {1,2,3,4}    {"aaa","bbb"}

append TEST (numbers="{1, 2, 3, 4}", strings="{aaa,}")
---also works but produces
 {1,2,3,4}    {"aaa",""} 

---note the "" (null)

append TEST (numbers="{1, 2, 3, 4}", strings="{aaa}")
---FAILS, output is:
 {1,2,3,4}    {}

---note the "aaa" value was not appended

It looks like a bug.  

              --------======= * =======--------
                       Steven Davidson
                       steved@cfcl.com