By default YSQL will display NULL as an empty string which makes it impossible to distinguish NULL from a true empty string […]
Read MoreClearing the Screen in YSQL
Lots of old school folks (like myself) use YSQL for administrative tasks. As you enter commands, eventually the command prompt will end […]
Read MoreGenerate a Random Date Between Two Dates
As we learned in several earlier tips, we can create a random integer and a random string in YugabyteDB quite easily. But […]
Read MoreGet the DDL for an INDEX
The use of indexes can enhance database performance by enabling the database server to find rows faster. You can create, drop, and […]
Read MoreWhen Does NULL = NULL = TRUE?
Normally when comparing a NULL with a NULL for equality you’ll get a NULL result. But that can be overridden with the […]
Read More