function search_files_update_6203 in Search Files 7.2

Same name and namespace in other branches

1. 6.2 search_files.install \search_files_update_6203()

File

./search_files.install, line 59

Installation and update procedures for the search_files module.

Code

function search_files_update_6203() {
  $ret = array();

  /* add PostgreSQL support for concat() with three args, inspired by http://drupal.org/node/83974
   * taken from modules/system/system.install which already does the same trick for concat() with two args
   */
  if ($GLOBALS['db_type'] == 'pgsql') {
    if (!db_result(db_query("SELECT COUNT(*) FROM {pg_proc} WHERE proname = 'concat' AND pronargs = 3"))) {
      db_query("\n        CREATE OR REPLACE FUNCTION concat(text, text, text)\n        RETURNS text AS\n        'SELECT \$1 || \$2 || \$3;'\n        LANGUAGE 'sql'\n      ");
    }
  }
  return $ret;
}