On Thu, Feb 26, 2009 at 3:02 AM, Grzegorz Jaśkiewicz <gryzman@gmail.com> wrote:
> First of all, I wonder why the same query divided up in half - and
> using temporary table works as expected, and with everything together
I'm betting it's your use of generate_series(). You can get some
weird side effects because it sometimes gets run multiple times not
just the once you expect. I'm guessing that's what's biting you.