Postgres Pro
Downloads
Home   >   mailing lists

Re: Unexpected results with joins on dates - Mailing list pgsql-general

From Tim Uckun
Subject Re: Unexpected results with joins on dates
Date
Msg-id CAGuHJrPxYhthY8oEZHSHwT9g9C=CtXpUu8DQVJPqb3CUEppiPQ@mail.gmail.com
Whole thread Raw
In response to Re: Unexpected results with joins on dates  (David Johnston <polobo@yahoo.com>)
Responses Re: Unexpected results with joins on dates
List pgsql-general
Tree view 
On Tue, Jul 12, 2011 at 3:01 PM, David Johnston <polobo@yahoo.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.

pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: [HACKERS] Creating temp tables inside read only transactions
Next
From: Adrian Parker
Date:
Subject: Alter Columns with Triggers