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 AAA17042 for postgres-redist; Wed, 1 Feb 1995 00:29:17 -0800 Resent-From: POSTGRES mailing list Resent-Message-Id: <199502010829.AAA17042@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 AAA17032 for ; Wed, 1 Feb 1995 00:29:08 -0800 Received: from dec324 by mailgate.aist-nara.ac.jp (8.6.9+2.4W/2.8Wb/NAIST-1.5[gate]) id RAA01243; Wed, 1 Feb 1995 17:28:58 +0900 Received: by dec324.aist-nara.ac.jp (5.65+1.6W/2.7W-AIST/1.3) id AA04781; Wed, 1 Feb 95 17:28:57 GMT+0900 Message-Id: <9502010828.AA04781@dec324.aist-nara.ac.jp> To: postgres@postgres.Berkeley.EDU Subject: Tell about. Reply-To: yutaka-i@is.aist-nara.ac.jp 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: Wed, 01 Feb 1995 17:28:56 +0900 From: Drunkard Terry Resent-To: postgres-redist@postgres.Berkeley.EDU Resent-Date: Wed, 01 Feb 95 00:29:17 -0800 Resent-XMts: smtp I have a questioin. 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 want retrieve the name employs [ greg, jeff, terry ], below method is OK? * retrieve ( manager.name ) where employees="{"greg","jeff","terry"}" \g --- : Drunkard Terry : Graduate School of Information Science : Nara Institute of Science and Technology ============================================================================== 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/