In YSQL there is the familiar built-in function named RANDOM which generates a random value between 0 (inclusive) and 1 (exclusive). Although […]
Read More
Display Query Results in a Crosstab-like Representation in YSQLSH
Pivoting a the rows of a query’s result set into columns is magically simple using YSQLSH, YugabyteDB’s YSQL command line interface. The […]
Read MoreCombine SQL and YSQLSH Meta-commands on the Command Line
The YugabyteDB SQL shell (ysqlsh) provides a CLI for interacting with YugabyteDB using YSQL The -c flag pecifies that ysqlsh is to execute […]
Read MoreHash Function Result Depends on Data Type
yb_hash_code is a function that returns the hash of a set of given input values using the hash function DocDB uses to […]
Read MoreWildcard Search to Display YSQL Run-Time Control Parameters
YSQL configuration parameters play an important role in optimizing and enhancing database performance. The YSQL SHOW command allows inspection of the current […]
Read More