db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kim Moore <kmo...@google.com>
Subject User Defined Functions in a Group By Clause
Date Wed, 07 Jan 2009 00:49:00 GMT
I am working on a query that uses a user defined function in a group by
clause.

select myfunction (datecolumn)
         ,count(*)
from    table
group by myfunction (datecolumn)

Executing the query gives the error "The SELECT list of a group query
contains at least one invalid expression."

When I replace myfunction (user defined function) with a DATE function which
comes standard with Derby, the query works.

All help is greatly appreciated.

Kim

Mime
View raw message