Re: [SQL] Nested Views take forever

From: marten(at)feki(dot)toppoint(dot)de
To: tgl(at)sss(dot)pgh(dot)pa(dot)us (Tom Lane)
Cc: zot(at)zotconsulting(dot)com, pgsql-sql(at)hub(dot)org
Subject: Re: [SQL] Nested Views take forever
Date: 1999-11-12 07:42:26
Message-ID: 199911120742.IAA05096@feki.phoenix-edv.netzservice.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message marten 1999-11-12 07:55:30 Re: [SQL] HAVING in EXISTS-clause ...
Previous Message Tom Lane 1999-11-12 00:34:06 Re: [SQL] Nested Views take forever