On Fri, Feb 27, 2009 at 3:10 AM, Grzegorz Jaśkiewicz <gryzman@xxxxxxxxx> wrote: > 2009/2/27 Scott Marlowe <scott.marlowe@xxxxxxxxx>: >> On Thu, Feb 26, 2009 at 3:02 AM, Grzegorz Jaśkiewicz <gryzman@xxxxxxxxx> 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. > > in which case, wouldn't that be a postgresql's bug ? Nope. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general