Re: does a table always need a PK?
From: Lee Fesperman <firstsql_at_ix.netcom.com>
Date: Wed, 03 Sep 2003 07:55:08 GMT
Message-ID: <3F559DC5.7E91_at_ix.netcom.com>
Date: Wed, 03 Sep 2003 07:55:08 GMT
Message-ID: <3F559DC5.7E91_at_ix.netcom.com>
Mikito Harakiri wrote:
>
> "Lee Fesperman" <firstsql_at_ix.netcom.com> wrote in message
> news:3F553DDD.50EB_at_ix.netcom.com..
> > + SUM() is just one type of aggregate function. The other common
> > ones don't have a corresponding simple operator. The rules should
> > be the same for all aggregate functions.
>
> AVG = SUM(val)/SUM(1) is redundant
That's ugly. And, it is incorrect. I see no problem with shorthands like AVG().
-- Lee Fesperman, FirstSQL, Inc. (http://www.firstsql.com) ============================================================== * The Ultimate DBMS is here! * FirstSQL/J Object/Relational DBMS (http://www.firstsql.com)Received on Wed Sep 03 2003 - 09:55:08 CEST