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 MoreGenerate a Random Timestamp Between Two Timestamps
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 Table Size in YSQL
You can display the size of a YSQL table via the pg_table_size function. Example: yugabyte=# CREATE TABLE test (c1 INT); CREATE TABLE […]
Read MoreYSQL Function to Determine Data Type of Text
YSQL inherits from Postgres the built-in function pg_typeof function which returns the OID of the data type of the value that is […]
Read More