Adding upstream version 0.85.6.upstream/0.85.6

Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>

1 files changed, 38 insertions, 0 deletions

diff --git a/db/language.sql b/db/language.sql
new file mode 100644
index 0000000..e961ac7
--- /dev/null
+++ b/db/language.sql
@@ -0,0 +1,38 @@
+--- Debian Source Builder: Database Schema for PostgreSQL            -*- sql -*-
+---
+--- Copyright © 2008-2009 Roger Leigh <rleigh@debian.org>
+--- Copyright © 2008-2009 Marc 'HE' Brockschmidt <he@debian.org>
+--- Copyright © 2008-2009 Adeodato Simó <adeodato@debian.org>
+---
+--- This program is free software: you can redistribute it and/or modify
+--- it under the terms of the GNU General Public License as published by
+--- the Free Software Foundation, either version 2 of the License, or
+--- (at your option) any later version.
+---
+--- This program is distributed in the hope that it will be useful, but
+--- WITHOUT ANY WARRANTY; without even the implied warranty of
+--- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
+--- General Public License for more details.
+---
+--- You should have received a copy of the GNU General Public License
+--- along with this program.  If not, see
+--- <http://www.gnu.org/licenses/>.
+
+CREATE OR REPLACE FUNCTION create_plpgsql_language ()
+  RETURNS TEXT AS $$
+    CREATE LANGUAGE plpgsql;
+    SELECT 'language plpgsql created'::TEXT;
+$$
+LANGUAGE SQL;
+
+SELECT CASE WHEN
+ (SELECT 't'::boolean
+    FROM pg_language
+      WHERE lanname='plpgsql')
+  THEN
+    (SELECT 'language plpgsql already installed'::TEXT)
+  ELSE
+    (SELECT create_plpgsql_language())
+END;
+
+DROP FUNCTION create_plpgsql_language();