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: (view raw, whole thread or download thread mbox)
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?
(Use EXISTS instead of IN)

 Nabil Sayegh
 GPG-Key available at 
 (see 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-2017 The PostgreSQL Global Development Group