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

select myfunction (datecolumn)
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.


View raw message