Return-Path: pg_adm@postgres.berkeley.edu
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA15783; Wed, 14 Jul 93 04:54:52 -0700
Date: Wed, 14 Jul 93 04:54:52 -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: <D7B1263960000F28@ITC.NL>
X-Envelope-To: postgres@postgres.Berkeley.edu
X-Vms-To: POSTM
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		|
-----------------


Jide Kufoniyi
Dept of Geoinformatics,
ITC, P.O.Box 6,
7500AA Enschede, The Netherlands
e-mail kufoniyi@itc.nl