Return-Path: owner-postman Received: from localhost (localhost [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id JAA02858 for postgres-dist; Mon, 17 Jan 1994 09:04:58 -0800 Resent-From: POSTGRES mailing list Resent-Message-Id: <199401171704.JAA02858@nobozo.CS.Berkeley.EDU> X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost didn't use HELO protocol Sender: owner-postman@postgres.Berkeley.EDU X-Return-Path: owner-postman Received: from localhost (aoki@localhost) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) id JAA02846; Mon, 17 Jan 1994 09:04:56 -0800 Message-Id: <199401171704.JAA02846@nobozo.CS.Berkeley.EDU> From: aoki@postgres.Berkeley.EDU (Paul M. Aoki) To: Marina Ignatieva Cc: postgres@postgres.Berkeley.EDU Subject: Re: ? In-reply-to: Your message of Mon, 17 Jan 94 17:03:10 -0300 Date: Mon, 17 Jan 1994 09:04:56 -0800 X-Sender: aoki@postgres.Berkeley.EDU Resent-To: postgres-dist@postgres.Berkeley.EDU Resent-Date: Mon, 17 Jan 94 09:04:58 -0800 Resent-XMts: smtp Marina Ignatieva writes: > retrieve into mar (test.all,test1.all) \g > This gives: I think it must give: > --------------------------- ------------------------ > a b c d a b c d > --------------------------- ------------------------- > 1 2 3 4 1 2 3 4 > --------------------------- -------------------------- > 10 20 3 4 ? 10 20 30 40 > ---------------------------- ---------------------------- > 1 2 30 40 ? > --------------------------- > 10 20 30 40 > --------------------------- mar should contain the relational cross product of test and test1 (each item in test joined to each item in test1), so the answer is correct if you're actually retrieving the contents of mar. > retrieve mar (test.all,test1.all)\g this query shouldn't even parse, but "retrieve (mar.all)" or "retrieve (test.all,test1.all)" should both give the answer above. -- Paul M. Aoki | CS Div., Dept. of EECS, UCB | aoki@postgres.Berkeley.EDU | Berkeley, CA 94720 | ...!uunet!ucbvax!aoki