postgreSQL 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
--------
coalesce
--------
'first non null'
PGSQL> SELECT COALESCE(NULL, NULL, NULL);
coalesce
--------
In this page (written and validated by A. Gawali) you learned about postgreSQL Multiple non null arguments . What's Next? If you are interested in completing postgreSQL tutorial, your next topic will be learning about: postgreSQL Comments.
Share On: |