A unique index disallows duplicate values from being inserted into the indexed columns. But this does not apply to NULL values. Here […]
Read More
CLOSE ALL USER SESSIONS
You might need to close all user sessions connected to a YugabyteDB database if, for example, there is severe resource contention or […]
Read MoreAdd a Record to the Begining of an Array in a JSONB Column
YSQL supports the JSONB data type which stores a parsed representation of a JavaScript Object Notation (JSON) document hierarchy of subvalues in an appropriate internal format. […]
Read MoreAppend a Record to an Array in a JSONB Column
YSQL supports the JSONB data type which stores a parsed representation of a JavaScript Object Notation (JSON) document hierarchy of subvalues in an appropriate internal […]
Read MoreExtract Array Elements Into Rows
YugabyteDB allows columns of a table to be defined as variable-length multidimensional arrays. The UNNEST() function can be used later to expand […]
Read More