Return-Path: pg_adm@postgres.berkeley.edu Received: by postgres.Berkeley.EDU (5.61/1.29) id AA02873; Fri, 22 Jan 93 01:21:31 -0800 Date: Fri, 22 Jan 93 01:21:31 -0800 Message-Id: <9301220921.AA02873@postgres.Berkeley.EDU> From: mick Subject: Re: < ``arrays of arrays'' > To: postgres@postgres.berkeley.edu Sender: pg_adm@postgres.berkeley.edu Could someone explain which versions have the array code bug ? I re ran the original query on ver 4.0 and got the following . * 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 CREATE * APPEND 35951 * APPEND 35952 * APPEND 35953 * APPEND 35954 * retrieve (bla.all, bla.telno[1]) \g ------------------------------------------- | name | telno | telno | ------------------------------------------- | Hans | {"110","112"}| 110 | ------------------------------------------- | Anna | {"1164",""} | 1164 | ------------------------------------------- | Karl | {"1171",""} | 1171 | ------------------------------------------- | Susi | {"1191"} | 1191 | ------------------------------------------- Mick Ridley Dept of Computing Phoenix Bldg M.J.Ridley@bradford.ac.uk Univ of Bradford Bradford BD7 1DP 0274 383946 UK