Re: does a table always need a PK?

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)