Moin Drew,
Drew Jensen wrote:
| AVG
| MAX
| MIN
| SUM
| EVERY
| ANY
| SOME
| COUNT
| STDDEV_POP
| STDDEV_SAMP
| VAR_SAMP
| VAR_POP
| COLLECT
| FUSION
| INTERSECTION
Like Andrew earlier I'm wondering if I am just being tired here..but
I give up...
I found it in http://www.wiscorp.com/sql200n.zip
6WD2_02_Foundation_2007-12.pdf page 555 and thought when supporting SQL
than I support a little bit more while touching the code. As far as I
know hsqldb doesn't supports this at the moment.
What do fusion and collect do?
You'll find an explanation on page 561
ix) If FUSION is specified, then the result is the multiset M such that
for each value V in the element
type of DT, including the null value, the number of elements of M that
are identical to V is the
sum of the number of identical copies of V in the multisets that are the
values of the column in
each row of TXA.
x) If INTERSECTION is specified, then the result is a multiset M such
that for each value V in the
element type of DT, including the null value, the number of duplicates
of V in M is the minimum
of the number of duplicates of V in the multisets that are the values of
the column in each row
of TXA.
Best regards,
Ocke
PS: May be we should not offer fusion, collect and intersection in the UI.
Thanks
Drew
ps - that is a nice update for 3.1 by the way.
pps - and can one infer from the entry in the issue that Base will
support HSQLdb 1.9 and would that include all the features?
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
Ocke Janssen Tel: +49 40 23646 661, x66661
Dipl. Inf(FH) Fax: +49 40 23646 550
Sun Microsystems Inc.
Nagelsweg 55 mailto:[EMAIL PROTECTED]
D-20097 Hamburg http://www.sun.com/staroffice
Sitz der Gesellschaft: Sun Microsystems GmbH, Sonnenallee 1,
D-85551 Kirchheim-Heimstetten
Amtsgericht Muenchen: HRB 161028
Geschaeftsfuehrer: Thomas Schroeder Wolfgang Engels, Dr. Roland Boemer
Vorsitzender des Aufsichtsrates: Martin Haering
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
