OpenACS

gustafn
committed
oacs-5-9:gustafn:20170904062554
on 04 Sep 17
Fix typo in variable name "new_nls_language" (must be "new__nls_language")
/upgrade/upgrade-5.9.2d1-5.9.2d2.sql (+45)
  1 -- PG11 compatibility
  2 --
  3 -- procedure trigger_type/1
  4 --
  5 CREATE OR REPLACE FUNCTION trigger_type(
  6    tgtype integer
  7 ) RETURNS varchar AS $$
  8 DECLARE
  9   description       varchar;
  10   sep               varchar;
  11 BEGIN
  12
  13  if (tgtype & 2) > 0 then
  14     description := 'BEFORE ';
  15  else
  16     description := 'AFTER ';
  17  end if;
  18
  19  sep := '';
  20
  21  if (tgtype & 4) > 0 then
  22     description := description || 'INSERT ';
  23     sep := 'OR ';
  24  end if;
  25
  26  if (tgtype & 8) > 0 then
  27     description := description || sep || 'DELETE ';
  28     sep := 'OR ';
  29  end if;
  30
  31  if (tgtype & 16) > 0 then
  32     description := description || sep || 'UPDATE ';
  33     sep := 'OR ';
  34  end if;
  35
  36  if (tgtype & 1) > 0 then
  37     description := description || 'FOR EACH ROW';
  38  else
  39     description := description || 'STATEMENT';
  40  end if;
  41
  42  return description;
  43
  44 END;
  45 $$ LANGUAGE plpgsql IMMUTABLE;