From within the YSQLSH CLI you can use the ef metacommand to open the code for a function or procedure into the […]
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 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 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 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