Re: Antw: Re: Revised proposal for QUERY DTD
- From: "Gerhard Dieringer" <DieringG eba-haus de>
- To: <malerba linuxave net>
- Cc: <gnome-db-list gnome org>
- Subject: Re: Antw: Re: Revised proposal for QUERY DTD
- Date: Thu, 13 Jul 2000 16:25:37 +0200
You wrote:
> ...
> > - when you distinguish func and aggregate, then the attribute group in func/field is needless ?
>
> The distinction between functions and aggregates is there to the GROUP BY. But
> aren't some cases where the group attribute could be necessary?
> ...
You can use GROUP BY only in conjunction with aggregat functions.
Then you have to group by all attributes in the source list, that are not aggregated.
So if we have both the group attribute and the distinction between functions and aggregates it's redundant.
But as it simplifies the generation of SQL statements, I will accept it.
Another suggestion: We could put this distinction as an attribute to the func element:
<!ATTLIST func
aggregate (yes|no) "no"
......
Gerhard
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]