Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 9ED2C47628E for ; Tue, 28 Jan 2003 06:21:22 -0500 (EST) Received: from mail2.itxmarket.com (fw.itxmarket.com [213.11.40.109]) by postgresql.org (Postfix) with ESMTP id 0A9D0475AE4 for ; Tue, 28 Jan 2003 06:21:22 -0500 (EST) Received: from freebsdcluster.net (mich2.itxmarket.com [192.168.2.26]) by mail2.itxmarket.com (Postfix) with ESMTP id A753E37CA4 for ; Tue, 28 Jan 2003 12:21:23 +0100 (CET) Received: by freebsdcluster.net (Postfix, from userid 1000) id 56B5D3B943E; Tue, 28 Jan 2003 12:21:23 +0100 (CET) Date: Tue, 28 Jan 2003 12:21:23 +0100 From: Michael Hostbaek To: pgsql-sql@postgresql.org Subject: subselect return in where clause Message-ID: <20030128112123.GC67742@mich2.itxmarket.com> Mail-Followup-To: Michael Hostbaek , pgsql-sql@postgresql.org Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline X-Operating-System: FreeBSD 4.7-STABLE i386 X-PGP-Key: http://www.freebsdcluster.org/~mich/ User-Agent: Mutt/1.5.3i X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/428 X-Sequence-Number: 11293 Group, Is it possible to use a subselect result in a where statement ? If so, how ? Fx. select some_stuff, more_stuff, (select other_stuff from other_table where other_table.stuff ilike stuff.match) as other_stuff from stuff where other_stuff = 'hello' thanks. -- Best Regards, Michael Landin Hostbaek FreeBSDCluster.org - an International Community */ PGP-key available upon request /*