On 28/06/2021 00:52, Adrian Klaver wrote:
On 6/27/21 3:41 PM, Ray O'Donnell wrote:
Here's a slightly simplified example:
create table bookings (
booking_id bigint not null,
booking_time tstzrange not null,
constraint bookings_pk primary key (booking_id)
);
It seems to me this is missing some reference to what is being booked
e.g. room number.
Yes, indeed - I left out everything except what was immediately relevant
to my problem. The real table is actually for booking aircraft - it's
for the local flying club of which I'm a member - so there are columns
for aircraft registration, member details, etc.
Ray.
--
Raymond O'Donnell // Galway // Ireland
ray@xxxxxxxxxxxx
