Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 59DCE475EF9 for ; Mon, 6 May 2002 10:07:31 -0400 (EDT) Received: from stan.ringways.co.uk (unknown [213.38.87.130]) by postgresql.org (Postfix) with ESMTP id 8E70F4762C6 for ; Mon, 6 May 2002 09:10:20 -0400 (EDT) Received: from gary.ringways.co.uk ([10.1.1.2] helo=there) by stan.ringways.co.uk with smtp (Exim 3.33 #2) id 174iCk-0007r8-00 for pgsql-sql@postgresql.org; Mon, 06 May 2002 14:07:02 +0100 Content-Type: text/plain; charset="iso-8859-1" From: Gary Stainburn Organization: Ringways Garages Ltd To: pgsql-sql Subject: Re: summary VIEW Date: Mon, 6 May 2002 14:08:18 +0100 X-Mailer: KMail [version 1.3.2] References: In-Reply-To: MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Message-Id: X-Archive-Number: 200205/39 X-Sequence-Number: 7675 I've managed it by doing: create view capacity as SELECT matrixaircraft AS capaircraft, matrixseat AS capseat, sum(matrix.matrixwidth) AS capcount FROM matrix GROUP BY matrixaircraft, matrixseat; If there's a better way I'l appreciate being shown. Ta Gary On Monday 06 May 2002 12:41 pm, Gary Stainburn wrote: > Hi all, > > Taking that I have an aircraft seating table, as below, > > How could I create a VIEW to replace the capacity table shown underneath? > > create table matrix ( > matrixaircraft character varying (4) references aircraft(aircraftid) not > null, > matrixrow int4 not null, > matrixseat character references seating(seatid), > matrixwidth int4 not null, > primary key (matrixaircraft, matrixrow) > ); > > -- capacity should be a VIEW based on matrix > create table capacity ( > capaircraft character varying (4) references aircraft(aircraftid) not > null, capseat character references seating(seatid) not null, > capcount int4, > primary key (capaircraft, capseat) > ); -- Gary Stainburn This email does not contain private or confidential material as it may be snooped on by interested government parties for unknown and undisclosed purposes - Regulation of Investigatory Powers Act, 2000