The user manual available online at: http://www.hsqldb.org/web/ hsqlDocsFrame.html seems to have a typo. In the SQL synthax chapter where you describe the SELECT statement it's written,:

{ Expression | COUNT(*) | {COUNT | MIN | MAX | SUM | AVG | SOME | EVERY | VAR_POP | VAR_SAMP | STDDEV_POP | STDDEV_SAMP} ([ALL | DISTINCT][1]] Expression) } [[AS] label]

I think that there is a mistake with the brackets [ & ]:

at the end you close one time too much the bracket in [ALL | DISTINCT] [1]]

and you use double brackets in [[AS] label] where simple should be enought.

Regards Jérôme




-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems?  Stop!  Download the new AJAX search engine that makes
searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_idv37&alloc_id865&op=click
_______________________________________________
hsqldb-developers mailing list
hsqldb-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hsqldb-developers

Reply via email to