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

From Scott Marlowe
Subject Re: funny view/temp table problem with query
Date
Msg-id dcc563d10902270218t14d99c89k8d5bf3d7cc7d93cd@mail.gmail.com
Whole thread Raw
In response to Re: funny view/temp table problem with query  (Grzegorz Jaśkiewicz <gryzman@gmail.com>)
List pgsql-general
On Fri, Feb 27, 2009 at 3:16 AM, Grzegorz Jaśkiewicz <gryzman@gmail.com> wrote:
> 2009/2/27 Scott Marlowe <scott.marlowe@gmail.com>:
>> Nope.
>
> as far as I can understand it, if I do the same thing in two steps,
> and in one step. And the latter is broken, because of some internal
> process/optimization/whatever - that's a bug to me.

You're assuming that creating a temp data set in a table and join
semantics are the same.  they are not.

pgsql-general by date:

Previous
From: Grzegorz Jaśkiewicz
Date:
Subject: Re: funny view/temp table problem with query
Next
From: Linos
Date:
Subject: function to return rows as columns?