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
referencesseating(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