Skip site navigation (1) Skip section navigation (2)

Re: Nested Queries

From: Nabil Sayegh <nsmail(at)sayegh(dot)de>
To: ltt(at)pml(dot)ac(dot)uk
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Nested Queries
Date: 2001-01-17 12:51:54
Message-ID: 3A65956A.91FF5262@sayegh.de (view raw or flat)
Thread:
Lists: pgsql-novice
Luke Tudor - RSG wrote:
> 
> Hi,
> 
> I seem to have a small problem with my nested queries. Im sure its
> something so simple; If I run each query seperatly, I get the correct
> results and these results can be put into the parent query.
> However if the queries are run together as one nested query the results
> take
> hours and hours (more like days).

FAQ: 4.23) Why are my subqueries using IN so slow?

http://www.postgresql.org/docs/faq-english.html#4.23
(Use EXISTS instead of IN)

-- 
 Nabil Sayegh
 GPG-Key available at http://www.sayegh.de 
 (see http://www.gnupg.org for details)

In response to

pgsql-novice by date

Next:From: Paul Joseph McGeeDate: 2001-01-17 14:10:36
Subject: Type Creation
Previous:From: John PoltorakDate: 2001-01-17 12:29:31
Subject: Re: What am I doing wrong?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group