🚀 go-pugleaf

Hi,

> There is nothing to group. To use GROUP BY you must have at leas one
> aggregate function (MIN, MAX, COUNT, SUM, etc.) in the SELECT clause.
> If you want the result in a particular order use ORDER BY.

It's not mandatory to use an aggregate function if you've a GROUP BY clause, but Interbase doesn't 
support GROUP BY <ordinal>. Thus he must include the same expressions as in the select list into the 
GROUP BY clause, although IIRC Interbase doesn't support that too (EXTRACT(...) in the GROUP BY).
While using GROUP BY without aggregate functions is the same as DISTINCT is in this case DISTINCT 
anyway the best solution.

Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
General database development support:
  http://www.databasedevelopmentforum.com

Firebird open source database (based on IB-OE) with many SQL-99 features :
  http://www.firebirdsql.org
  http://www.firebirdsql.info
  http://www.fingerbird.de/
  http://www.comunidade-firebird.org/

Support list for Firebird and Interbase users :
firebird-support@yahoogroups.com

Nederlandse firebird nieuwsgroep :
news://newsgroups.firebirdsql.info