summary VIEW

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