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 GAA02250 for postgres-dist; Mon, 17 Jan 1994 06:55:53 -0800 Resent-From: POSTGRES mailing list Resent-Message-Id: <199401171455.GAA02250@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 sequent.kiae.su (sequent.kiae.su [144.206.136.6]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id GAA02234 for ; Mon, 17 Jan 1994 06:55:45 -0800 Received: by sequent.kiae.su id AA20215 (5.65.kiae-1 for postgres@postgres.berkeley.edu); Mon, 17 Jan 1994 17:07:34 +0300 Received: by ibrae.msk.su (UUPC/@ v5.09gamma, 14Mar93); Mon, 17 Jan 1994 17:03:12 -0300 To: postgres@postgres.Berkeley.EDU Message-Id: Organization: Nuclear Safety Institute From: Marina Ignatieva Date: Mon, 17 Jan 94 17:03:10 -0300 X-Mailer: BML [MS/DOS Beauty Mail v.1.36] Lines: 30 Resent-To: postgres-dist@postgres.Berkeley.EDU Resent-Date: Mon, 17 Jan 94 06:55:52 -0800 Resent-XMts: smtp Dear Gurus! I'm using on Postgres 4.1 on SunSparc running Soloris 4.1. I can't undestand the one moment in the "retrieve" statetment. I create some relations: create test(a=int4,b=int4)\g create test1(c=int4,d=int4)\g append test(a=1,b=2)\g append test1(c=3,d=4)\g append test (a=10,b=20)\g append test1 (c=30,d=40)\g retrieve into mar (test.all,test1.all) \g retrieve 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 --------------------------- Can somebody tell me what is wrong? Best regards, Marina Ignatieva (ign@ibrae.msk.su)