Return-Path: postman 
Delivery-Date: Sat, 28 Aug 93 14:11:44 PDT
Return-Path: postman
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA08408; Sat, 28 Aug 93 14:09:34 -0700
Resent-From: postman (POSTGRES mailing list)
Resent-Message-Id: <9308282109.AA08408@postgres.Berkeley.EDU>
Sender: owner-postman@postgres.Berkeley.EDU
X-Return-Path: vivek@pollux.cs.uga.edu
Received: from pollux.cs.uga.edu by postgres.Berkeley.EDU (5.61/1.29)
	id AA08400; Sat, 28 Aug 93 14:09:28 -0700
Received: by pollux.cs.uga.edu (4.1/25-eef)
	id AA11443; Sat, 28 Aug 93 17:19:16 EDT
From: Vivek Shivpuri <vivek@pollux.cs.uga.edu>
Message-Id: <9308282119.AA11443@pollux.cs.uga.edu>
Subject: Array type question???
To: postgres@postgres.berkeley.edu
Date: Sat, 28 Aug 1993 17:19:16 -0400 (EDT)
X-Mailer: ELM [version 2.4 PL21]
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Content-Length: 1495      
Resent-To: postgres-dist
Resent-Date: Sat, 28 Aug 93 14:09:33 PDT

Below within dotted lines is a monitor session :


_________________________________________________________________________
 
 * create yy(name = int4[4]) \g

 Query sent to backend is "create yy(name = int4[4]) "
 CREATE
 Go 
 * append yy(name = "{1,2,34,5}") \g

 Query sent to backend is "append yy(name = "{1,2,34,5}") "
 APPEND 131243
 Go 
 * append yy(name = "{1,2,3}") \g

 Query sent to backend is "append yy(name = "{1,2,3}") "
 APPEND 131244
 Go 
 * append yy(name = "{1,2}") \g

 Query sent to backend is "append yy(name = "{1,2}") "
 APPEND 131245
 Go 
 * append yy(name = "{1}") \g  ---------------->>>>>>> THIS CAUSES THE PROBLEM

Query sent to backend is "append yy(name = "{1}") " 
APPEND 131246
 Go 
 * retrieve (yy.all) \g

 Query sent to backend is "retrieve (yy.all) "
 ---------------
 | name        |
 ---------------
 | {1,2,34,5}  |
 ---------------
 | {1,2,3}     |
 ---------------
 | {1,2}       |
 ---------------
 | {}          |  -------------->>>>>>>> THIS IS THE PROBLEM
 ---------------

 Go 
 * 

 _________________________________________________________________________


 My question is why does the 4th member of "name" (see problem indication
 above) not work. That is why can't we append only one element. 

 Any solutions around this.....or suggestions would be greatly appreciated.

 Thanks

 Vivek.

-- 
Vivek Shivpuri, CS Dept, 415 GSRC Bldg  | PHONE: [+1] (706)-613-0582 
University Of Georgia, Athens GA30602.  | EMAIL: vivek@pollux.cs.uga.edu