Case-insensitive search in YSQL is a much-requested feature, most likely to ease the migration from Microsoft SQL Server to YugabyteDB. You can […]
Read MoreGenerate a Series of Dates in YSQL
The generate_series YugabyteDB SQL built-in function is a set returning function in that it can return more than one row. It comes […]
Read MoreUNICODE Linestyle for Query Results in YSQLSH
By default the YSQLSH CLI draws the lines that separate the columns and rows of a result set using ascii characters. Example: […]
Read MoreLoad and Edit Stored Procedure Code in YSQLSH
From within the YSQLSH CLI you can use the ef metacommand to open the code for a function or procedure into the […]
Read MoreMaximum Number of Columns Per Index
The use of indexes can enhance YugabyteDB’s performance by enabling the database server to find rows faster. You can create, drop, and […]
Read More