Return-Path: pg_adm@postgres.berkeley.edu
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA21929; Tue, 19 Jan 93 11:58:29 -0800
Message-Id: <9301191958.AA21929@postgres.Berkeley.EDU>
From: rot@unlisys.IN-Berlin.DE (Robert Rothe)
Subject: < ``arrays of arrays'' >
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu
To: postgres@postgres.berkeley.edu
Date: Tue, 19 Jan 1993 21:01:04 +0100 (MET)
X-Mailer: ELM [version 2.4 PL20]
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Length: 913       


hi,

is the following behavior concerning the entry 'Susi' correct ?

create bla (name=char16, telno=text[])  \g

append bla (name="Hans", telno = "{ "110", "112" }") \g
append bla (name="Anna", telno = "{ "1164", "" }"  ) \g
append bla (name="Karl", telno = "{ "1171",  }"    ) \g
append bla (name="Susi", telno = "{ "1191" }"      ) \g

retrieve (bla.all, bla.telno[1]) \g

---------------------------------------------
| name        | telno         | telno       |
---------------------------------------------
| Hans        | {"110","112"} | 110         |
---------------------------------------------
| Anna        | {"1164",""}   | 1164        |
---------------------------------------------
| Karl        | {"1171",""}   | 1171        |
---------------------------------------------
| Susi        | {}            | (null)      |
---------------------------------------------


thanx for info,
	robert.