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 <gryzman@gmail.com>)
Ответы Re: funny view/temp table problem with query  (Grzegorz Jaśkiewicz <gryzman@gmail.com>)
Список pgsql-general
Дерево обсуждения 
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.

В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: overlaps behaviour - ('2006-03-01'::TimeStamp, '2007-12-01'::TimeStamp) overlaps ('2007-12-01'::TimeStamp, 'Infinity'::TimeStamp)
Следующее
От: "Dann Corbit"
Дата:
Сообщение: Kerberos V5 required for PostgreSQL installation on Windows