function date_sql_coalesce in Date 5.2
Same name and namespace in other branches
- 8 date_api/date_api.module \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()
- 7.2 date_api/date_api_sql.inc \date_sql_coalesce()
Helper function to do cross-database NULL replacements
Parameters
an array of values to test for NULL values:
Return value
SQL statement to return the first non-NULL value in the list.
1 call to date_sql_coalesce()
- _date_views_query_alter in date/
date_views.inc - Implementation of hook_views_query().
File
- ./
date_api_sql.inc, line 26
Code
function date_sql_coalesce($array) {
global $db_type;
switch ($db_type) {
case 'mysql':
case 'mysqli':
case 'pgsql':
return "COALESCE(" . implode(',', $array) . ")";
}
}