Hi Manatel,

I'm writing off list as this is related to donations. We would welcome 
donations as mentioned on our web site.

I would like to clarify the feature that you require. The SUM(<string 
expression>) aggregate function would return the concatenations of the 
strings in different rows. So if there are three rows with the data given 
below, the result would be

COLA    | COLB
-----------------
apple       10
orange     8
pear         3


Then SELECT SUM(COLA) FROM ATABLE will return

appleorangepear

And SELECT SUM(COLA || ' ') FROM ATABLE will return

apple orange pear

But if there is any condtion in the SELECT, the order of strings may be 
different


SELECT SUM(COLA) FROM ATABLE where COLB >0

pearorangeapple

Please clarify and confirm exactly what you require

Regards

Fred
----- Original Message ----- 
From: matanel deutsch
To: Developer issues for the hsqldb Database Engine.
Sent: 23 October 2007 09:57
Subject: Re: [Hsqldb-developers] String aggregate functions


hi fred,
thanks for the quick response,
I looked at the code and it was very useful and easy to change,
I have another question:
Is it possible to enter this feature(string concat) to the next official 
release of hsqldb, we don't want to handle our own version of hsqldb,
we are considering paying/donating for it.
thanks
MATANEL





From: [EMAIL PROTECTED]
To: hsqldb-developers@lists.sourceforge.net
Date: Mon, 22 Oct 2007 22:24:41 +0100
Subject: Re: [Hsqldb-developers] String aggregate functions


There may be something in the patches section.

The class that handles the aggregates is SetFunction and it is relatively 
easy to add new functions to this class. But references to any new function 
should also be added to Parser and Expression classes, so that they are 
recognised and evaluated.

Fred
----- Original Message ----- 
From: matanel deutsch
To: hsqldb-developers@lists.sourceforge.net
Sent: 18 October 2007 13:09
Subject: [Hsqldb-developers] String aggregate functions


hi,
I am interesting about string aggregate function in hsqldb and I saw some of 
the subscription about SetFunction class under hsqldb 
project.(http://www.opensubscriber.com/message/hsqldb-developers@lists.sourceforge.net/2105323.html)
Is there any solutions for string aggregate function??
Is there any patch that support this feature and if yes how can I download 
it and use it?
thanks,



MATANEL



Windows Live Hotmail and Microsoft Office Outlook – together at last. Get it 
now!



-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/




_______________________________________________
hsqldb-developers mailing list
hsqldb-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hsqldb-developers




Help yourself to FREE treats served up daily at the Messenger Café. Stop by 
today!



-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/



_______________________________________________
hsqldb-developers mailing list
hsqldb-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hsqldb-developers 


-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
hsqldb-developers mailing list
hsqldb-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hsqldb-developers

Reply via email to