>>>>>>>>>>>> Army wrote (2006-10-26 15:25:49): >> [...] >> // Doesn't work but seems like it could/should based on above queries... > > ij> select sin(i) from t1 group by sin(i); > ERROR 42Y30: The SELECT list of a grouped query contains at least one > invalid expression. If a SELECT list has a GROUP BY, the list may only > contain valid grouping expressions and valid aggregate expressions. > [...]
To me it seems natural that this one doesn't work. To group by double or float values is not reasonable. -- Bernt Marius Johnsen, Database Technology Group, Staff Engineer, Technical Lead Derby/Java DB Sun Microsystems, Trondheim, Norway
signature.asc
Description: Digital signature
