On Thu, Feb 26, 2009 at 3:02 AM, Grzegorz Jaśkiewicz <[email protected]> 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.

-- 
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to