> From: [email protected] [mailto:pgsql-sql-
> [email protected]] On Behalf Of Gary Stainburn
> Sent: Monday, July 13, 2009 9:12 AM
>
> If a date exists where we have orders but no deliveries the row does
not
> appear.
> I have tried doing a union to link the two selects together, b
> From: [email protected] [mailto:pgsql-sql-
> [email protected]] On Behalf Of [email protected]
> Sent: Thursday, July 09, 2009 1:53 PM
>
> I've simplified the query to make it easier to look at.
>
> This one doesn't use the index's and therefore takes about 11713ms to
> return.
Hav