Received: from trends.net (root@clio.trends.ca [209.47.148.2])
	by hub.org (8.9.3/8.9.3) with ESMTP id XAA01977
	for <pgsql-sql@postgresql.org>; Tue, 7 Dec 1999 23:05:23 -0500 (EST)
	(envelope-from cgriffin@websales.com)
Received: from websales.com (root@websales.com [192.153.125.97])
	by trends.net (8.8.8/8.8.8) with ESMTP id VAA05349
	for <pgsql-sql@postgresql.org>; Tue, 7 Dec 1999 21:25:50 -0500 (EST)
Received: from [207.67.207.131] (webcc-isdn-131.webcc.net [207.67.207.131])
	by websales.com (8.9.3/8.8.5) with ESMTP id SAA29940
	for <pgsql-sql@postgresql.org>; Tue, 7 Dec 1999 18:02:49 -0800
User-Agent: Microsoft Outlook Express Macintosh Edition - 5.0 (1513)
Date: Tue, 07 Dec 1999 17:58:57 -0800
Subject: Re: [SQL] select distinct?
From: Chris Griffin <cgriffin@websales.com>
To: <pgsql-sql@postgresql.org>
Message-ID: <B472FB61.124A%cgriffin@websales.com>
In-Reply-To: <B472EE78.1247%cgriffin@websales.com>
Mime-version: 1.0
Content-type: text/plain; charset="US-ASCII"
Content-transfer-encoding: 7bit


 I found the email tom posted on the 4th about this same thing. I tried a
variation on the suggestion in that email and it still complained:  "Illegal
use of aggregates or non-group column in target list".