Re: Unexpected results with joins on dates

From: Tim Uckun <timuckun(at)gmail(dot)com>
To: David Johnston <polobo(at)yahoo(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Unexpected results with joins on dates
Date: 2011-07-12 10:12:52
Message-ID: CAGuHJrPxYhthY8oEZHSHwT9g9C=CtXpUu8DQVJPqb3CUEppiPQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Jul 12, 2011 at 3:01 PM, David Johnston <polobo(at)yahoo(dot)com> wrote:
> If traffic has 5 records on a date and sales has 4 on the same date you would output 20 records for that date.

What would I have to do in order to get 9 records instead of 20. Like
a union but with dissimilar schema.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jonathan Barber 2011-07-12 11:59:22 Re: Slow queries (high duration) and their log entries appearing out-of-order
Previous Message Alban Hertroys 2011-07-12 10:08:18 Re: [HACKERS] Creating temp tables inside read only transactions