2nd June 2021
Computer Science⚑
GNULinux⚑
(../computer_science/gnu_linux/mdadm.md)⚑
- New: Extend RAID0.
(../computer_science/gnu_linux/postgresql.md)⚑
- New: Stop/kill a process.
-
New: NULLIF function.
The (https://www.postgresql.org/docs/current/functions-conditional.html#FUNCTIONS-NULLIF) function returns a null value if
value1
equalsvalue2
; otherwise it returnsvalue1
.It can be useful for avoiding divisions by 0 (e.g. set
value2
to 0). -
New: Numeric data types reference.
- New: Add column.
- New: Concat_ws.
-
New: Window functions.
Window functions allow to perform the calculation across a set of rows related to the current row.
-
New: UPDATE from subquery.
Other⚑
-
New: UPDATE.
To update the values of some columns, use (https://www.postgresql.org/docs/9.1/sql-update.html).