Is the COALESCE a function of the ANSI SQL especification? Is it supported by the major relational databases?
Is Coalesce a function of ANSI SQL
Yes:
https://www.mssqltips.com/sqlservertip/2689/deciding-between-coalesce-and-isnull-in-sql-server/
From the article:
Some think that you need to use COALESCE because it is the only one that adheres to the ANSI SQL standard.
and Yes.
The ISO/ANSI SQL standard specification ISO/IEC 9075-2:2023(E), Annex H, SQL mandatory feature taxonomy, lists CASE
and COALESCE
as mandatory features:
F261 CASE expression
F261-04 COALESCE
COALESCE
is also an ISO/ANSI SQL reserved word (https://en.wikipedia.org/wiki/List_of_SQL_reserved_words)
Yes, COALESCE is defined by the ISO/ANSI SQL standards.
© 2022 - 2024 — McMap. All rights reserved.
ANSI SQL:2011 SQL standard
and there's only a few databases that are supporting it so far (although many are catching up or have similar-ish or partial temporal functionality).COALESCE()
is everywhere though and a standard (92, I think). – AgcCOALESCE()
is not available in MS Access – StricklanCOALESCE()
is ISO/ANSI standard SQL. It is available in almost all databases (all if you don't include MS Access). – RubricCASE
it also supportsCOALESCE
andNULLIF
, both are shortcuts. – Victory