Received: from trillium.nmsu.edu (trillium.NMSU.Edu [128.123.5.15]) by hub.org (8.8.8/8.7.5) with ESMTP id SAA26314 for ; Mon, 29 Jun 1998 18:28:21 -0400 (EDT) Received: (from brook@localhost) by trillium.nmsu.edu (8.8.8/8.8.8) id QAA05019; Mon, 29 Jun 1998 16:28:03 -0600 (MDT) Date: Mon, 29 Jun 1998 16:28:03 -0600 (MDT) Message-Id: <199806292228.QAA05019@trillium.nmsu.edu> From: Brook Milligan To: pgsql-sql@postgreSQL.org Subject: IN and subselects I am having problems getting IN in WHERE clauses to work together with subselects. That is, I want to do something like select * from a where a.id in (select id from b where b.n = 7); The typical outcome is that no rows are selected even though some match the criterion. Doing the equivalent EXISTS condition will often work, but I cannot always get it to work. Is there a known problem with using IN? Thanks for your help. Cheers, Brook