Re: funny view/temp table problem with query

[Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>]

On Fri, Feb 27, 2009 at 3:10 AM, Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com> wrote:
> 2009/2/27 Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>:
>> On Thu, Feb 26, 2009 at 3:02 AM, Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)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.
>
> in which case, wouldn't that be a postgresql's bug ?

Nope.