pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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






view thread (3+ messages)

Message-ID: <199911120742.IAA05096@feki.phoenix-edv.netzservice.de>
Permalink:  ../199911120742.IAA05096@feki.phoenix-edv.netzservice.de/
Also on:    postgresql.org/message-id/199911120742.IAA05096@feki.phoenix-edv.netzservice.de

 · 

reply

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