Re: Concatenating text from multiple rows

2008-06-30 Thread Six Fried Rice
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

Re: Concatenating text from multiple rows

2008-06-30 Thread Rick Hillegas
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

Concatenating text from multiple rows

2008-06-30 Thread Six Fried Rice
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