Re: funny view/temp table problem with query

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
Cc: Alban Hertroys <dalroi(at)solfertje(dot)student(dot)utwente(dot)nl>, PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: funny view/temp table problem with query
Date: 2009-02-27 01:22:47
Message-ID: dcc563d10902261722v7d8fed57y2df5c795ce7a4724@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dann Corbit 2009-02-27 01:30:53 Kerberos V5 required for PostgreSQL installation on Windows
Previous Message Adrian Klaver 2009-02-27 01:13:14 Re: overlaps behaviour - ('2006-03-01'::TimeStamp, '2007-12-01'::TimeStamp) overlaps ('2007-12-01'::TimeStamp, 'Infinity'::TimeStamp)