I was today years old when I learned about unnesting multiple arrays as in this example. It is awesome.
One could also have the where clause for this as t is not null. But that is semantical.
Personally I prefer to not have identical code in select and where clauses, but this solution stays +1
Getting the following error on codewars ->
PG::SyntaxError: ERROR: unterminated dollar-quoted string at or near "$$
But not receiving the error when I do the kata on a local instance.
Any ideas?
This was a very refreshing Kata. I thoroughly enjoyed it.
Yup!
I was today years old when I learned about unnesting multiple arrays as in this example. It is awesome.
One could also have the where clause for this as t is not null. But that is semantical.
Personally I prefer to not have identical code in select and where clauses, but this solution stays +1
Getting the following error on codewars ->
PG::SyntaxError: ERROR: unterminated dollar-quoted string at or near "$$
But not receiving the error when I do the kata on a local instance.
Any ideas?
I think for the example scenario "char_length" is better suited than "length".