agora inbox for postgres@postgres.berkeley.edu  

help / color / mirror / Atom feed

From: Robert.Patrick@cs.cmu.edu
To: postgres@postgres.Berkeley.EDU
Subject: Re: arrays of arrays
Date: Sat, 11 Feb 1995 20:35:21 -0500 (EST)
Message-ID: <4jDKLNu00hPeJAA1Fg@cs.cmu.edu> (raw)
In-Reply-To: <9502110050.AA00610@dec324.aist-nara.ac.jp>
References: <9502110050.AA00610@dec324.aist-nara.ac.jp>

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/

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: Robert.Patrick@cs.cmu.edu
  Subject: Re: arrays of arrays
  In-Reply-To: <4jDKLNu00hPeJAA1Fg@cs.cmu.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