agora inbox for postgres@postgres.berkeley.edu  

help / color / mirror / Atom feed

From: Robert Rothe <rot@unlisys.IN-Berlin.DE>
To: postgres@postgres.berkeley.edu
Subject: < ``arrays of arrays'' >
Date: Tue, 19 Jan 1993 21:01:04 +0100 (MET)
Message-ID: <9301191958.AA21929@postgres.Berkeley.EDU> (raw)


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.

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: rot@unlisys.IN-Berlin.DE
  Subject: Re: < ``arrays of arrays'' >
  In-Reply-To: <9301191958.AA21929@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