summaryrefslogtreecommitdiff
path: root/database/database.pgsql
diff options
context:
space:
mode:
authorDries Buytaert <dries@buytaert.net>2002-11-08 13:11:42 +0000
committerDries Buytaert <dries@buytaert.net>2002-11-08 13:11:42 +0000
commit86a3ebefd3fb4313f521dadbd8b420aa2ba64084 (patch)
treedba506a239763d49d594cfb4dfbf7cece064afdd /database/database.pgsql
parentea6ce100a1c121c8646ec7fa88d7120ca93cb840 (diff)
downloadbrdo-86a3ebefd3fb4313f521dadbd8b420aa2ba64084.tar.gz
brdo-86a3ebefd3fb4313f521dadbd8b420aa2ba64084.tar.bz2
- Made the forum module work with PostgreSQL. Patch by Gordon Kerr, verified
by James Arthur.
Diffstat (limited to 'database/database.pgsql')
-rw-r--r--database/database.pgsql13
1 files changed, 13 insertions, 0 deletions
diff --git a/database/database.pgsql b/database/database.pgsql
index 0784f4b74..c40381ccb 100644
--- a/database/database.pgsql
+++ b/database/database.pgsql
@@ -608,3 +608,16 @@ INSERT INTO blocks(name,module,delta,status) VALUES('User information', 'user',
DELETE FROM blocks WHERE name='Log in';
INSERT INTO blocks(name,module,delta,status) VALUES('Log in', 'user', '1', '1');
+---
+--- Functions
+---
+
+CREATE FUNCTION "greatest"(integer, integer) RETURNS integer AS '
+BEGIN
+ IF $1 > $2 THEN
+ RETURN $1;
+ END IF;
+ RETURN $2;
+END;
+' LANGUAGE 'plpgsql';
+