PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.
allows the use of CASE as a conditional expression in addition to IF-THEN