Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: PostgreSQL <pgsql-general(at)postgresql(dot)org>
- Subject: Re: funny view/temp table problem with query
- Date: Fri, 27 Feb 2009 03:18:26 -0700
- Message-id: <dcc563d10902270218t14d99c89k8d5bf3d7cc7d93cd@mail.gmail.com> <text/plain>
On Fri, Feb 27, 2009 at 3:16 AM, Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com> wrote: > 2009/2/27 Scott Marlowe <scott(dot)marlowe(at)gmail(dot)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.
- References:
- funny view/temp table problem with query
- From: Grzegorz Jaśkiewicz
- Re: funny view/temp table problem with query
- From: Alban Hertroys
- Re: funny view/temp table problem with query
- From: Grzegorz Jaśkiewicz
- Re: funny view/temp table problem with query
- From: Scott Marlowe
- Re: funny view/temp table problem with query
- From: Grzegorz Jaśkiewicz
- Re: funny view/temp table problem with query
- From: Scott Marlowe
- Re: funny view/temp table problem with query
- From: Grzegorz Jaśkiewicz
- funny view/temp table problem with query
- Prev by Date: Re: funny view/temp table problem with query
- Next by Date: function to return rows as columns?
- Previous by thread: Re: funny view/temp table problem with query
- Next by thread: Using xmin to identify last modified rows
- Indexes: