On Jun 30, 2008, at 6:18 AM, Rick Hillegas wrote:
I don't understand the distinction you are drawing between Derby and
the Java side. Derby functions let you run your Java code inside the
database. You can create a user-defined function which loops through
custom_function_parameter inside y
Hi Geoff,
This sounds like a good use for a user-defined aggregate (DERBY-672).
Most of the machinery for this feature actually exists inside Derby. We
would have to agree on some syntax for declaring user-defined aggregates
since ANSI doesn't have language for this. I'd be happy to coach some
I have a table "CUSTOM_FUNCTION" with an ID, and another table
"CUSTOM_FUNCTION_PARAMETER" with a foreign key "ID_CUSTOM_FUNCTION"
such that each CUSTOM_FUNCTION record has 0 or more associated
CUSTOM_FUNCTION_PARAMETER records.
In one situation, it would be exceptionally handy to concatena