X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 41729D7F1F
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 14 Oct 2005 04:21:13 -0300 (ADT)
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 76927-02
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 14 Oct 2005 07:21:05 +0000 (GMT)
Received: from stark.xeocode.com (stark.xeocode.com [216.58.44.227])
	by svr1.postgresql.org (Postfix) with ESMTP id C99CDD774A
	for <pgsql-sql@postgresql.org>; Fri, 14 Oct 2005 04:21:05 -0300 (ADT)
Received: from localhost ([127.0.0.1] helo=stark.xeocode.com)
	by stark.xeocode.com with smtp (Exim 3.36 #1 (Debian))
	id 1EQJsD-0000Qa-00; Fri, 14 Oct 2005 03:21:02 -0400
To: "Anthony Molinaro" <amolinaro@wgen.net>
Cc: "Greg Stark" <gsstark@MIT.EDU>,
	"Scott Marlowe" <smarlowe@g2switchworks.com>,
	"Stephan Szabo" <sszabo@megazone.bigpanda.com>,
	"Rick Schumeyer" <rschumeyer@ieee.org>, <pgsql-sql@postgresql.org>
Subject: Re: pg, mysql comparison with "group by" clause
References: <3C6C2B281FD3E74C9F7C9D5B1EDA4582182620@wgexch01.wgenhq.net>
In-Reply-To: <3C6C2B281FD3E74C9F7C9D5B1EDA4582182620@wgexch01.wgenhq.net>
From: Greg Stark <gsstark@mit.edu>
Organization: The Emacs Conspiracy; member since 1992
Date: 14 Oct 2005 03:21:01 -0400
Message-ID: <87ll0wh8de.fsf@stark.xeocode.com>
Lines: 19
User-Agent: Gnus/5.09 (Gnus v5.9.0) Emacs/21.4
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.011 required=5 tests=[AWL=0.011]
X-Spam-Level: 
X-Archive-Number: 200510/152
X-Sequence-Number: 23005


"Anthony Molinaro" <amolinaro@wgen.net> writes:

> More awkward? What *you're* suggesting is more awkward. You realize that
> right? How can syntax that is understood and accepted for years be more
> awkward?

Well gosh, I would say that that's something only a newbie could say about
SQL of all things...

I had a whole thing written after that but I just deleted it. I grow tired of
this thread.

I am pretty happy to hear that the SQL standard endorsed the idea having the
right thing happen if the primary key is present in the grouping list. That
would be a wonderful feature for Postgres.

-- 
greg