Return-Path: owner-postman
Received: from localhost.Berkeley.EDU (localhost.Berkeley.EDU [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.9/8.6.3) with SMTP id RAA22608 for postgres-redist; Sat, 11 Feb 1995 17:36:10 -0800
Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199502120136.RAA22608@nobozo.CS.Berkeley.EDU>
X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost.Berkeley.EDU didn't use HELO protocol
Sender: owner-postman@postgres.Berkeley.EDU
X-Return-Path: owner-postman
Received: from RASAM.NDIM.EDRC.CMU.EDU (RASAM.NDIM.EDRC.CMU.EDU [128.2.214.234]) by nobozo.CS.Berkeley.EDU (8.6.9/8.6.3) with SMTP id RAA22598 for <postgres@postgres.BERKELEY.EDU>; Sat, 11 Feb 1995 17:35:34 -0800
Received: from Messages.8.5.N.CUILIB.3.45.SNAP.NOT.LINKED.rasam.ndim.edrc.cmu.edu.pmax.ul4
          via MS.5.6.rasam.ndim.edrc.cmu.edu.pmax_ul4;
          Sat, 11 Feb 1995 20:35:21 -0500 (EST)
Message-ID: <4jDKLNu00hPeJAA1Fg@cs.cmu.edu>
Date: Sat, 11 Feb 1995 20:35:21 -0500 (EST)
From: Robert.Patrick@cs.cmu.edu
To: postgres@postgres.Berkeley.EDU
Subject: Re: arrays of arrays
In-Reply-To: <9502110050.AA00610@dec324.aist-nara.ac.jp>
References: <9502110050.AA00610@dec324.aist-nara.ac.jp>
X-Sender: rp2y@RASAM.NDIM.EDRC.CMU.EDU
Resent-To: postgres-redist@postgres.Berkeley.EDU
Resent-Date: Sat, 11 Feb 95 17:35:50 -0800
Resent-XMts: smtp

Excerpts from internet.postgres: 11-Feb-95 arrays of arrays Drunkard
Terry@is.aist-n (1109*)

> When I create the attribute and append some value below...
>  
> * create manager (name = char16, employees = text[] ) \g

> * append manager (name = "mike",
> 		  employees = "{"wei", "greg", "jeff", "terry"}" ) \g
> * append manager (name = "alice",
> 		  employees = "{"bill", "joe", "terry"}" ) \g	

> So, I tried query below..

> * retrieve ( manager.name ) where
> manager.employees="{"greg","jeff","terry"}" \g

> return the message below..
> ------------------------
> WARN:Feb 11 09:44:15:OperatorDef: no operator =
> ------------------------

> I missed the syntax?


That's funny, 

 rasam.ndim.edrc.cmu.edu> monitor test
Welcome to the POSTGRES terminal monitor

Go 
* create manager(name=char16, employees=text[])\g

Query sent to backend is "create manager(name=char16, employees=text[])"
CREATE
Go 
* append manager(name="mike",
                employees="{"wei", "greg", "jeff", "terry"}")\g

Query sent to backend is "append manager(name="mike",          
employees="{"wei", "greg", "jeff", "terry"}")"
APPEND 36606
Go 
* append manager (name="alice",
                employees="{"bill","joe","terry"}")\g

Query sent to backend is "append manager (name="alice",                
employees="{"bill","joe","terry"}")"
APPEND 36607
Go 
* retrieve (manager.name) where
        manager.employees="{"greg","jeff","terry"}"\g

Query sent to backend is "retrieve (manager.name) where        
manager.employees="{"greg","jeff","terry"}""
---------------
| name        |
---------------

Go 
* \q
 rasam.ndim.edrc.cmu.edu>

Cheers,
Robert

==============================================================================
   To add/remove yourself to/from the POSTGRES mailing list: send mail with 
   the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU".
   If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
   a human will deal with it.  DO NOT post to the "postgres" mailing list.
==============================================================================
              URL: http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/