Re: table design

From: "hostel Nate " <nate1001(at)gmail(dot)com>
To: "Phillip Smith" <phillip(dot)smith(at)weatherbeeta(dot)com(dot)au>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: table design
Date: 2007-04-30 08:11:21
Message-ID: 4f0672b50704300111g41b9189lf1d2b54c30100ccc@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I think I see what the problem is now. My first attempt was with Reservation
and Paid Guest tables only and combine the queries to check all bookings.
But, I was trying to use LEFT JOIN for the view. The inheritance example
shows using UNION for a similar problem, which I think will take away my
headaches.

Thanks.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Michael Swierczek 2007-04-30 13:40:02 Re: PGSQL Query
Previous Message Phillip Smith 2007-04-30 07:16:39 Re: table design