Categorical data type that sorts by dictionary order?

[nmichaud]

Would be useful for sorting a list of days or months without needing a separate column

[deepankarsharma]

So something like an enum?

[nmichaud]

yeah, important part is that a pivot on that type has a sort order that might not be alphabetical, and all categories should be in the pivot even if no underlying rows have that value

[deepankarsharma]

Serves like good semantics for enum.

…

On Sat, Dec 1, 2018 at 2:05 PM Naveen Michaud-Agrawal < ***@***.***> wrote: yeah, important part is that a pivot on that type has a sort order that might not be alphabetical, and all categories should be in the pivot even if no underlying rows have that value — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#35 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AAzSwSUZ6mTrlfYVnPjTmoI0IK9tO1l5ks5u0tMWgaJpZM4Y2zON> .

[deepankarsharma]

On second thought - maybe we can make it configurable on the pivot on whether to include all categories or just the ones that are present?

[nmichaud]

Yeah agreed, since each column has it's own vocab. And the way to get a defined order can be done by insertion order into the vocab, and then using that for sorting?

…

On Sat, Dec 1, 2018, 2:22 PM Deepankar Sharma ***@***.*** wrote: On second thought - maybe we can make it configurable on the pivot on whether to include all categories or just the ones that are present? — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#35 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AAnj_mMBtqMqFQ8x6GQ_2fDiNLS3_Brvks5u0tbngaJpZM4Y2zON> .

[deepankarsharma]

Vocabs might go away soon.

[nmichaud]

Are you still going to do interning?

…

On Sat, Dec 1, 2018, 4:20 PM Deepankar Sharma ***@***.*** wrote: Vocabs might go away soon. — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#35 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AAnj_uZGBSGmHzcbCSRvkYOw5GBXhi_oks5u0vKAgaJpZM4Y2zON> .

[deepankarsharma]

Have not decided on details yet, but the only thing decided is that the current scheme wont stay.