agora inbox for postgres@postgres.berkeley.edu  

help / color / mirror / Atom feed

From: Drunkard Terry <yutaka-i@is.aist-nara.ac.jp>
To: postgres@postgres.Berkeley.EDU
Subject: arrays of arrays
Date: Sat, 11 Feb 1995 09:50:13 +0900
Message-ID: <9502110050.AA00610@dec324.aist-nara.ac.jp> (raw)

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?


---------------- Terry [G'Job !]

==============================================================================
   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: yutaka-i@is.aist-nara.ac.jp
  Subject: Re: arrays of arrays
  In-Reply-To: <9502110050.AA00610@dec324.aist-nara.ac.jp>

* 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