Return-Path: pg_adm@postgres.berkeley.edu
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA15745; Wed, 14 Jul 93 04:50:20 -0700
Date: Wed, 14 Jul 93 04:50:20 -0700
From: KUFONIYI@ITC.NL
Subject: RE:Aggregate count + where-clause
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu
To: postgres@postgres.Berkeley.edu
Message-Id: <D70FBD6C60000F28@ITC.NL>
X-Envelope-To: postgres@postgres.Berkeley.edu
X-Vms-To: POSTM
X-Vms-Cc: KUFONIYI
Content-Transfer-Encoding: 7BIT

For the count operator to use the where clause, the clause should be
inside the curly braces with the attrib. I tried this and it worked:

* retrieve (nr = count{rel.oid where rel.b > 7}) \g

Query sent to backend is "retrieve (nr = count{rel.oid where rel.b > 7})"

-----------------
| nr		|
-----------------
| 1		|
-----------------