From: marten@feki.toppoint.de
To: tgl@sss.pgh.pa.us
Cc: zot@zotconsulting.com
Cc: pgsql-sql@hub.org
Subject: Re: [SQL] Nested Views take forever
Date: Fri, 12 Nov 1999 08:42:26 +0100 (CET)
Message-ID: <199911120742.IAA05096@feki.phoenix-edv.netzservice.de> (raw)
In-Reply-To: <21836.942366846@sss.pgh.pa.us>
>
> There's been some talk of reimplementing WHERE ... IN ... so that it
> does something intelligent without help, but there are a lot of
> higher-priority problems on the TODO list...
>
> regards, tom lane
This only affect statement, where the "inner" select accesses some
stuff of the "outer" select statement ? Actually a statement like:
select * from table where index in
(select foreign-key from table2 where table2.name = 'Hallo')
would not have such problems ? Correct ?
Marten
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: marten@feki.toppoint.de, tgl@sss.pgh.pa.us, zot@zotconsulting.com, pgsql-sql@hub.org
Subject: Re: [SQL] Nested Views take forever
In-Reply-To: <199911120742.IAA05096@feki.phoenix-edv.netzservice.de>
References: <21836.942366846@sss.pgh.pa.us> <199911120742.IAA05096@feki.phoenix-edv.netzservice.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox