Re: funny view/temp table problem with query

Поиск
Список
Период
Сортировка
Искать
От
Scott Marlowe
Тема
Re: funny view/temp table problem with query
Дата
Msg-id
dcc563d10902261722v7d8fed57y2df5c795ce7a4724@mail.gmail.com
Ответ на
Re: funny view/temp table problem with query (Grzegorz Jaśkiewicz)
Список
Дерево обсуждения
funny view/temp table problem with query Grzegorz Jaśkiewicz <gryzman@gmail.com>
Re: funny view/temp table problem with query Grzegorz Jaśkiewicz <gryzman@gmail.com>
Re: funny view/temp table problem with query Alban Hertroys <dalroi@solfertje.student.utwente.nl>
Re: funny view/temp table problem with query Grzegorz Jaśkiewicz <gryzman@gmail.com>
Re: funny view/temp table problem with query Alban Hertroys <dalroi@solfertje.student.utwente.nl>
Re: funny view/temp table problem with query "Joshua D. Drake" <jd@commandprompt.com>
Re: funny view/temp table problem with query Gregory Stark <stark@enterprisedb.com>
Re: funny view/temp table problem with query Grzegorz Jaśkiewicz <gryzman@gmail.com>
Re: funny view/temp table problem with query Scott Marlowe <scott.marlowe@gmail.com>
Re: funny view/temp table problem with query Grzegorz Jaśkiewicz <gryzman@gmail.com>
Re: funny view/temp table problem with query Scott Marlowe <scott.marlowe@gmail.com>
Re: funny view/temp table problem with query Grzegorz Jaśkiewicz <gryzman@gmail.com>
Re: funny view/temp table problem with query Scott Marlowe <scott.marlowe@gmail.com> 
On Thu, Feb 26, 2009 at 3:02 AM, Grzegorz Jaśkiewicz  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.
В списке pgsql-general по дате отправления
Предыдущее
От: Adrian Klaver
Дата:
Следующее
От: Dann Corbit
Дата:
FAQ