Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread Extension to LIST function
Fri, Jun 12 2015 2:43 AMPermanent 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 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate 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
Image