agora inbox for postgres@postgres.berkeley.edu
help / color / mirror / Atom feedFrom: mick <M.J.Ridley@comp.brad.ac.uk>
To: postgres@postgres.berkeley.edu
Subject: Re: < ``arrays of arrays'' >
Date: Fri, 22 Jan 93 01:21:31 -0800
Message-ID: <9301220921.AA02873@postgres.Berkeley.EDU> (raw)
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
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: postgres@postgres.berkeley.edu
Cc: M.J.Ridley@comp.brad.ac.uk
Subject: Re: < ``arrays of arrays'' >
In-Reply-To: <9301220921.AA02873@postgres.Berkeley.EDU>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox