Home > mailing lists

SELECT .. WHERE field IN (SELECT .. ) - Mailing list pgsql-sql

From	Predrag Lesic
Subject	SELECT .. WHERE field IN (SELECT .. )
Date	July 27, 1999 12:39:18
Msg-id	379D7A0E.C840D9C2@cg.yu Whole thread Raw
List	pgsql-sql

Tree view

I have problem with next query

SELECT COUNT(*) FROM TABLE1 WHERE field1 IN (SELECT DISTINCT field2
FROM TABLE2 WHERE field3>'some date')

Processing time of the query is toooooooooo long. I didn't get the
answer. Postgres is doing something, I can see disk is working for some
time, and the query is running. But how long?????

Thank's
Predrag

pgsql-sql by date:

From: Don Yury
Date: 27 July 1999, 12:38:24
Subject: outer joins

From: Herouth Maoz
Date: 27 July 1999, 13:36:10
Subject: Re: [INTERFACES] How can I work thru this key problem?

SELECT .. WHERE field IN (SELECT .. ) - Mailing list pgsql-sql

Previous

Next