Getting started with postgresqlJSON SupportRole ManagementCommon Table Expressions (WITH)Accessing Data ProgrammaticallyBackup and RestoreTable CreationINSERTUPDATEDates, Timestamps, and IntervalsAggregate FunctionsProgramming with PL/pgSQLInheritancePostgreSQL High AvailabilityTriggers and Trigger FunctionsEXTENSION dblink and postgres_fdwWindow FunctionsPostgres Tip and TricksBackup script for a production DBComments in postgresqlExport PostgreSQL database table header and data to CSV fileData TypesRecursive queriesPostgres cryptographic functionsEvent TriggersSELECTConnect to PostgreSQL from JavaFind String Length / Character LengthCOALESCE
COALESCE
Single non null argument
PGSQL> SELECT COALESCE(NULL, NULL, 'HELLO WORLD');
coalesce
--------
'HELLO WORLD'
Multiple non null arguments
PGSQL> SELECT COALESCE(NULL, NULL, 'first non null', null, null, 'second non null');
coalesce
--------
'first non null'
All null arguments
PGSQL> SELECT COALESCE(NULL, NULL, NULL);
coalesce
--------
Contributors
Topic Id: 10576
Example Ids: 31753,31754,31755
This site is not affiliated with any of the contributors.