Re: [SQL] simple join is beating me

2009-07-13 Thread Hartman, Matthew
> 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

Re: [SQL] FW: Query length limitation in postgres server > 8.2.9

2009-07-09 Thread Hartman, Matthew
> 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