Appendix A — FAQ

Does EdgeSet support window functions?

Yes.

Does EdgeSet support CTEs (Common Table Expressions)?

Yes.

How does EdgeSet handle tables with different collations?

EdgeSet does not support setting or using collation(s). All string comparison and sorting is done by comparing unicode code points literally. For case-insensitive comparison, you can use LOWER(), UPPER(), or case-insensitive regular expressions. Note that these functions don’t support languages that have ambiguous case conversion (i.e. where one lowercase character could be represented various uppercase versions), but that should only be an issue if dealing with Eastern European languages.