Dirk
Thanks for pointing this out. That's definitely a bug. It'll be fixed in
3.20 beta
3 (probably several weeks away), but if it's urgent I can probably get a
patch to you a bit quicker.
Regards
Peter Hearty
Lutris Technologies (UK)
----- Original Message -----
From: "Dirk Jesko" <jesko@iti.cs.uni-magdeburg.de>
To: <instantdb@enhydra.org>
Sent: Monday, August 28, 2000 9:25 AM
Subject: InstantDB: Aggregates and user-defined functions
> Hello,
>
> I wrote user-defined function formattime. The function accepts Integer,
> Long, and Date values and returns a String. If I execute a statement
> like
>
> SELECT formattime(time_col) ...
>
> the function returns the desired strings, while
>
> SELECT formattime(sum(time_col))
>
> throws a SQLException.
>
> I did some tests with the example functions that come with InstantDB and
> found that if such a function is placed around an aggregate it either
> throws an SQLException (without further information) or it returns an
> empty result set.
>
> Does InstantDB not allow results of aggregates to be passed to user
> defined-functions?
>
>
> Thanks,
> Dirk
> --------------------------------------------------------------------------
---
> To unsubscribe from this mailing list, send email to majordomo@enhydra.org
> with the text "unsubscribe instantdb" in the body of the email.
> If you have other questions regarding this mailing list, send email to
> the list admin at owner-instantdb@enhydra.org.
>
-----------------------------------------------------------------------------
To unsubscribe from this mailing list, send email to majordomo@enhydra.org
with the text "unsubscribe instantdb" in the body of the email.
If you have other questions regarding this mailing list, send email to
the list admin at owner-instantdb@enhydra.org.
|