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 QAA18519 for postgres-redist; Fri, 10 Feb 1995 16:50:24 -0800 Resent-From: POSTGRES mailing list Resent-Message-Id: <199502110050.QAA18519@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 mailgate.aist-nara.ac.jp (fsb1.aist-nara.ac.jp [163.221.76.12]) by nobozo.CS.Berkeley.EDU (8.6.9/8.6.3) with ESMTP id QAA18509 for ; Fri, 10 Feb 1995 16:50:21 -0800 Received: from dec324 by mailgate.aist-nara.ac.jp (8.6.9+2.4W/2.8Wb/NAIST-1.5[gate]) id JAA11396; Sat, 11 Feb 1995 09:50:18 +0900 Received: by dec324.aist-nara.ac.jp (5.65+1.6W/2.7W-AIST/1.3) id AA00610; Sat, 11 Feb 95 09:50:14 GMT+0900 Message-Id: <9502110050.AA00610@dec324.aist-nara.ac.jp> To: postgres@postgres.Berkeley.EDU Subject: arrays of arrays Reply-To: yutaka-i@is.aist-nara.ac.jp In-Reply-To: Your message of "Wed, 01 Feb 1995 17:28:56 +0900" X-Mailer: Mew beta version 0.84 on Emacs 18.59.1, Mule 1.1 Mime-Version: 1.0 Content-Type: Text/Plain; charset=us-ascii Date: Sat, 11 Feb 1995 09:50:13 +0900 From: Drunkard Terry Resent-To: postgres-redist@postgres.Berkeley.EDU Resent-Date: Fri, 10 Feb 95 16:50:24 -0800 Resent-XMts: smtp 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/