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 KAA23851 for postgres-redist; Tue, 4 Oct 1994 10:13:05 -0700 Resent-From: POSTGRES mailing list Resent-Message-Id: <199410041713.KAA23851@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 homer10.u.washington.edu (homer10.u.washington.edu [140.142.78.11]) by nobozo.CS.Berkeley.EDU (8.6.9/8.6.3) with SMTP id KAA23841 for ; Tue, 4 Oct 1994 10:13:04 -0700 Received: by homer10.u.washington.edu (5.65+UW94.4/UW-NDC Revision: 2.30 ) id AA16546; Tue, 4 Oct 94 10:13:00 -0700 X-Sender: wei@homer10.u.washington.edu Date: Tue, 4 Oct 1994 10:12:59 -0700 (PDT) From: Xinguo Wei Subject: Questions on Virtual Attributes, again!... To: postgres@postgres.Berkeley.EDU In-Reply-To: <9410032238.AA14527@mdd.comm.mot.com> Message-Id: Mime-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Resent-To: postgres-redist@postgres.Berkeley.EDU Resent-Date: Tue, 04 Oct 94 10:13:05 -0700 Resent-XMts: smtp Hi, My email account is having some problems in receiving mail. So I am sending my question using a diffent account now. Sorry for the confusion. --------------------------------------------------------------------------- Hi, I am testing the virtual attribute function using the SET expression and I have two questions here. 1. When define the attribute using X = setof Y, the keyword "setof" seems not necessary if Y is a class name, i.e., "members = EMP" is the same as "members = setof EMP". If Y is not a class name, then "setof" is needed. Am I right? 2. In the following test case, I defined a set attribute for DEPT. But I couldn't find the way to retrive its value!! Please help me. create EMP (name = text, dept = text)\g create DEPT (name = text, emp_no = setof int4) \g append EMP (name = "a", dept = "candy")\g append EMP (name = "b", dept = "candy")\g append DEPT (name = "candy", EMP_no = "retrieve (a = count{EMP.name where EMP.dept = \\"candy\\"})") \g retrieve (DEPT.name, DEPT.emp_no) \g Query sent to backend is "retrieve (dept.name, dept.emp_no) " ----------------------------- | name | emp_no | ----------------------------- | candy | 25252 | ----------------------------- The value of emp_no here looks like an OID. What kind of object is that? How can i get the correct value of 2 ? Thanks!! Xinguo Wei wei@u.washington.edu ============================================================================== 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. ==============================================================================