db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Manish Khettry" <manish.khet...@gmail.com>
Subject Re: GROUP_BY with user functions
Date Fri, 15 Sep 2006 17:43:27 GMT
User functions can't be used in group by clauses although post 883 we do
allow expressions. User functions can be variant-- i.e. return different
values given the same arguments  and hence  not applicable  to group on.

m

On 9/15/06, Suavi Ali Demir <demir4@yahoo.com> wrote:
>
> It seems you want all the repeating values next to each other? Would a
> sort help? Does order by work?
> Regards,
> Ali
>
>
> *Robert Enyedi <robert.enyedi@intland.com>* wrote:
>
> Does Derby support user functions in GROUP BY clauses?
>
> I'm thinking of the following scenario:
>
> SELECT USER_FUNCTION(t1.column1)
> FROM TABLE t1
> GROUP BY USER_FUNCTION(t1.column1);
>
> When I tried this with the latest 10.2.1.3 beta version, this is the
> error I get:
>
> 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.
>
> Any ideas?
>
> Thanks,
> Robert
>
>
>

Mime
View raw message