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 IAA27254 for postgres-redist; Mon, 29 Aug 1994 08:31:35 -0700 Resent-From: POSTGRES mailing list Resent-Message-Id: <199408291531.IAA27254@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 cacofonix (root@cacofonix.utr.ac.za [192.96.20.3]) by nobozo.CS.Berkeley.EDU (8.6.9/8.6.3) with SMTP id IAA27244 for ; Mon, 29 Aug 1994 08:31:19 -0700 Message-Id: Subject: Multi-key indices in postgres. To: postgres@postgres.Berkeley.EDU (Postgres Database) Date: Mon, 29 Aug 1994 16:39:38 +0200 (GMT+0200) From: "Mr N.L. Parker" X-Mailer: ELM [version 2.4 PL23] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Length: 740 Resent-To: postgres-redist@postgres.Berkeley.EDU Resent-Date: Mon, 29 Aug 94 08:31:35 -0700 Resent-XMts: smtp Hi Newbie question: Is there an easy way to create multi-key indices in Postgres - have browsed the manual but looks like it gets complicated ..? Maybe I am missing something obvious. eg What is the POSTQUEL equivalent of the following SQL: CREATE TABLE SP (Sno char(5), Pno char(5), Qty integer, primary key (Sno, Pno), foreign key (Sno) references S, foreign key (Pno) references P ) ; S and P are tables which are already set up and are indexed on Sno and Pno respectively. Neil -- Neil Parker Just * Computer Centre, University of Transkei visiting * Pvt Bag X1 Umtata . Tel (0471)-3022461 * this Email: ccnp@unitrix.utr.ac.za * Planet ! ============================================================================== 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. ==============================================================================