Date: Mon, 5 Jun 2006 07:10:07 -0400
From: Andrew Sullivan <ajs@crankycanuck.ca>
To: pgsql-sql@postgresql.org
Subject: Re: Using Query Result in WHERE Clause
Message-ID: <20060605111007.GA4832@phlogiston.dyndns.org>
References: <20060602200640.91950.qmail@web33304.mail.mud.yahoo.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <20060602200640.91950.qmail@web33304.mail.mud.yahoo.com>
User-Agent: Mutt/1.5.9i

On Fri, Jun 02, 2006 at 01:06:40PM -0700, operationsengineer1@yahoo.com wrote:
> hi all,
> 
> SUMMARY:
> 
> i want to replace
> 
> AND t_inspect.inspect_pass = 'f'
> 
> with a complex query that yields the same result.  the
> complex query is in the form of...

[snip]

But your complex query isn't in the form where anything will come out
"= 'f'".  You have too many columns in the SELECT.

What you prabably need to do is rewrite it as a subquery in the FROM
clause, alias it as (say) alias_t_inspect, and then use your
condition to get you what you want.   I won't warrant what the
performance will be, however.

A


-- 
Andrew Sullivan  | ajs@crankycanuck.ca
If they don't do anything, we don't need their acronym.
		--Josh Hamilton, on the US FEMA