function date_sql_coalesce in Date 7.2
Same name and namespace in other branches
- 8 date_api/date_api.module \date_sql_coalesce()
- 5.2 date_api_sql.inc \date_sql_coalesce()
- 6.2 date_api_sql.inc \date_sql_coalesce()
- 7.3 date_api/date_api_sql.inc \date_sql_coalesce()
- 7 date_api/date_api_sql.inc \date_sql_coalesce()
Helper function to do cross-database NULL replacements.
Parameters
array $array: An array of values to test for NULL values.
Return value
string SQL statement to return the first non-NULL value in the list.
File
- date_api/
date_api_sql.inc, line 41 - SQL helper for Date API.
Code
function date_sql_coalesce(array $array) {
switch (Database::getConnection()
->databaseType()) {
case 'mysql':
case 'pgsql':
return "COALESCE(" . implode(',', $array) . ")";
}
}