Re: [SQL] Nested Views take forever - Mailing list pgsql-sql

From marten@feki.toppoint.de
Subject Re: [SQL] Nested Views take forever
Date
Msg-id 199911120742.IAA05096@feki.phoenix-edv.netzservice.de
Whole thread Raw
In response to Re: [SQL] Nested Views take forever  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
> 
> 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





pgsql-sql by date:

Previous
From: "Klein, Robert"
Date:
Subject: Trying to move a 6.1 database to 6.5
Next
From: marten@feki.toppoint.de
Date:
Subject: Re: [SQL] HAVING in EXISTS-clause ...