X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id BB970329C67
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon, 20 Sep 2004 17:32:42 +0100 (BST)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 21816-02
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon, 20 Sep 2004 16:32:38 +0000 (GMT)
Received: from tht.net (vista.tht.net [216.126.88.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 9EAE4329C63
	for <pgsql-sql@postgresql.org>; Mon, 20 Sep 2004 17:32:38 +0100 (BST)
Received: from [134.22.69.205] (dyn-69-205.tor.dsl.tht.net [134.22.69.205])
	by tht.net (Postfix) with ESMTP
	id 1627576A54; Mon, 20 Sep 2004 12:31:38 -0400 (EDT)
Subject: Re: COUNT(*) to find records which have a certain number of
From: Rod Taylor <pg@rbt.ca>
To: mailreg@numerixtechnology.de
Cc: pgsql-sql@postgresql.org
In-Reply-To: <414F02FF.8000603@numerixtechnology.de>
References: <414F02FF.8000603@numerixtechnology.de>
Content-Type: text/plain
Message-Id: <1095697895.86376.3.camel@jester>
Mime-Version: 1.0
X-Mailer: Ximian Evolution 1.4.6 
Date: Mon, 20 Sep 2004 12:31:36 -0400
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No,
 hits=0.3 tagged_above=0.0 required=5.0 tests=UPPERCASE_25_50
X-Spam-Level: 
X-Archive-Number: 200409/162
X-Sequence-Number: 19008

On Mon, 2004-09-20 at 12:19, T E Schmitz wrote:
> I figured it eventually. (The only thing I don't know is where to put
> the ORDER BY.)

Try this:
        
        SELECT brand_name, model_name
          FROM (SELECT ... INTERSECT SELECT ...) AS t
        ORDER BY ...