Login
Products
Sales
Support
Downloads
About
Home
»
Technical Support
»
ElevateDB Technical Support
»
Support Forums
»
ElevateDB Enhancement Requests and Suggestions
»
View Thread
View Thread
The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Extension to LIST function
Fri, Jun 12 2015 2:43 AM
Permanent Link
Adam Brett
Orixa Systems
The LIST function currently accepts STRING data-types.
I quite often have to write this:
SELECT
LIST(CAST(ID as VARCHAR(20))) as IDs
FROM xxxx
It is not complicated SQL at all, but if the LIST function also accepted NUMERIC datatypes I could write this:
SELECT
LIST(ID) as IDs
FROM xxxx
which is simpler.
If overloading the function is hard or unwise an additional function like "LISTNUMBERS" would be an alternative.
... I know I can write that myself, but I think it would be generally useful.
Fri, Jun 12 2015 4:07 AM
Permanent Link
Roy Lambert
NLH Associates
Team Elevate
Adam
I'm a lazy BOF but I'd vote against it unless it was extended to cope with all datatypes, unless that I'm happier with just the one.
Roy Lambert