Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 4 of 4 total
Thread Could the LIST SQL Keyword create lists of Integers as well as VARCHARs?
Thu, Jun 28 2018 12:03 PMPermanent Link

Adam Brett

Orixa Systems

I have a good number of Integer fields in my databases, which users want to see in lists.

I can write this:

SELECT
 LIST(CAST(<IntegerField> as VARCHAR)) as FMIDs
FROM <MyTable>

.... but

SELECT
 LIST(<IntegerField>) as FMIDs
FROM <MyTable>

would be easier.

It is a tiny change I know.
Fri, Jun 29 2018 2:27 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Adam


If your suggestion was to automagically convert all datatypes to VARCHAR I'd support it. After all LIST is "simply" creating a VARCHAR with specified separators. Different datatypes would, I suspect, be a nightmare for Tim and for us as well.

Roy Lambert
Fri, Jun 29 2018 12:57 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Adam,

<< would be easier. >>

Yeah, I certainly get that, but I'm not sure about starting to introduce features that perform implicit type conversions when the rest of the SQL is very much statically-typed.

If the expression was producing an array of integers or something that was logically related to the input type, then I would say sure, but integers into a string, hmmm.....

Tim Young
Elevate Software
www.elevatesoft.com
Sat, Jun 30 2018 2:11 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Tim


>If the expression was producing an array of integers or something that was logically related to the input type, then I would say sure, but integers into a string, hmmm.....

Oh goody - you're adding array column types into ElevateDB

Roy
Image