Non grouping version of LIST function
-------------------------------------

                 Key: CORE-4335
                 URL: http://tracker.firebirdsql.org/browse/CORE-4335
             Project: Firebird Core
          Issue Type: New Feature
            Reporter: Tim Kelly


I frequently concatenate different fields together, but it would be useful to 
be able to do this separating the result with commas.

I propose a new non-grouping version of LIST function, say STRINGLIST this 
would basically concatenate string versions of it's arguments but correctly 
place commas (so there is no comma at the end of the list).

SELECT STRINGLIST('A','B','C') FROM RDB$DATABASE:

----
STRINGLIST
A,B,C
----

SELECT STRINGLIST('A',NULL,'C') FROM RDB$DATABASE

---
STRINGLIST
A,C
---

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

------------------------------------------------------------------------------
Android apps run on BlackBerry 10
Introducing the new BlackBerry 10.2.1 Runtime for Android apps.
Now with support for Jelly Bean, Bluetooth, Mapview and more.
Get your Android app in front of a whole new audience.  Start now.
http://pubads.g.doubleclick.net/gampad/clk?id=124407151&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to