function views_update_6007 in Views (for Drupal 7) 6.2

Same name and namespace in other branches

1. 6.3 views.install \views_update_6007()
2. 7.3 views.install \views_update_6007()

Add aggregate function to PostgreSQL so GROUP BY can be used to force only one result to be returned for each item.

File

./views.install, line 384

views.install Contains install and update functions for Views.

Code

function views_update_6007() {
  $ret = array();
  if ($GLOBALS['db_type'] == 'pgsql') {
    $ret[] = update_sql('CREATE OR REPLACE FUNCTION first(anyelement, anyelement) RETURNS anyelement AS \'SELECT COALESCE($1, $2);\' LANGUAGE \'sql\';');
    $ret[] = update_sql("DROP AGGREGATE IF EXISTS first(anyelement)");
    $ret[] = update_sql("CREATE AGGREGATE first(sfunc = first, basetype = anyelement, stype = anyelement);");
  }
  return $ret;
}