Columns that have a SERIAL data type are auto-incremented. YugabyteDB supports SMALLSERIAL, SERIAL, and BIGSERIAL which are short notation for sequences of […]
Read More
Generate a Random Decimal Number between Two Values
In YSQL there is the familiar built-in function named RANDOM which generates a random value between 0 (inclusive) and 1 (exclusive). Although […]
Read MoreDisplay 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 More