This was pretty eye-opening to me. I had no idea you could use multiplication with booleans like this. Thanks for the lesson!

TRIM(to_char(cast(hits as float) / cast(at_bats as float), '0.999')) as batting_average

^^^^^^
This worked for me, although it looks sloppy

Cute.

Inserting at 0 is not very efficient as it copies the whole string every time. It is better to simply push (to a Vec for example) and reverse everything at the end.

I like cider. :)

You should have replaced $emp_stamp$ with something that's not straight out of PostgreSQL documentation.

Format strings with free "bonus" whitespace—that's one of the more ridiculous language "features" I've seen in a while! 😆

This is whitespace. If you wrap your expression in length(), it will show 6 symbols

This is whitespace. If you wrap your expression in length(), it will show 6 symbols

same issue, even though iam outputting with to_char

Other answers used tuples (your_type, opponent_type) as keys to the dict instead of plain strings.

Limiting the list of numbers to (length list) is unnecesary and requires an additional traversal of the list just to know the length. If you write [1..] Haskell is clever enough to generate the list on demand, and zip will stop as soon as one of the lists is exhausted (a property that greatly simplifies its use in Haskell).

It's right, but it's not right enough. LOL Also, it is text.