Menu
▾
▴
Re: [Hsqldb-developers] String aggregate functions
|
From: fredt <fr...@us...> - 2007-10-26 12:24:45
|
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: fr...@us... To: hsq...@li... 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: hsq...@li... 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/hsq...@li.../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 hsq...@li... 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 hsq...@li... https://lists.sourceforge.net/lists/listinfo/hsqldb-developers |
