Received: from mx99.openu.ac.il (arbel.openu.ac.il [147.233.32.4]) by hub.org (8.9.3/8.9.3) with ESMTP id HAA42264 for ; Sun, 20 Jun 1999 07:39:04 -0400 (EDT) (envelope-from herouth@oumail.openu.ac.il) Received: from talmon.openu.ac.il (talmon.openu.ac.il [147.233.32.11]) by mx99.openu.ac.il (Postfix) with ESMTP for id 6FB804B628; Sun, 20 Jun 1999 14:39:01 +0300 (IDT) Received: from [147.233.159.109] (mac-herouth.pc.openu.ac.il) by talmon.openu.ac.il (Netscape Messaging Server 3.54) with ESMTP id AAA12BE; Sun, 20 Jun 1999 14:41:47 +0300 X-Sender: herouth@shaked.cc.openu.ac.il Message-Id: In-Reply-To: <199906162007.QAA05181@hub.org> References: <24839.929543079@sss.pgh.pa.us> Your message of Wed, 16 Jun 1999 09:55:37 +0100 Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Date: Sun, 20 Jun 1999 14:40:16 +0300 To: rgireyev@cnmnetwork.com, pgsql-sql@postgreSQL.org From: Herouth Maoz Subject: Re: [SQL] DISTINCT count(*), possible? At 23:08 +0300 on 16/06/1999, Rudy Gireyev wrote: > > Out of curiosity, more than anything else. > Would the group by solve this problem? No. What you need is the number of groups, not the number of members in each group, which is what group by provides. Herouth -- Herouth Maoz, Internet developer. Open University of Israel - Telem project http://telem.openu.ac.il/~herutma