Re: funny view/temp table problem with query - Mailing list pgsql-general

From Grzegorz Jaśkiewicz
Subject Re: funny view/temp table problem with query
Date
Msg-id 2f4958ff0902270210t27a2addbndfc9fce6bdb9ccec@mail.gmail.com
Whole thread Raw
In response to Re: funny view/temp table problem with query  (Scott Marlowe <scott.marlowe@gmail.com>)
Responses Re: funny view/temp table problem with query  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-general
2009/2/27 Scott Marlowe <scott.marlowe@gmail.com>:
> 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.

in which case, wouldn't that be a postgresql's bug ?




--
GJ

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Question about no unchanging update rule + ALTER
Next
From: Scott Marlowe
Date:
Subject: Re: funny view/temp table problem with query