From c16ada8c46dd66f08a0432bee7bff6a436e58584 Mon Sep 17 00:00:00 2001
From: Steven Wittens <steven@10.no-reply.drupal.org>
Date: Thu, 22 Jul 2004 01:31:33 +0000
Subject: - #7295: Fixing issue with latest comments being incorrectly
 displayed on PostgreSQL

---
 database/database.pgsql | 5 ++++-
 1 file changed, 4 insertions(+), 1 deletion(-)

(limited to 'database/database.pgsql')

diff --git a/database/database.pgsql b/database/database.pgsql
index 1ce84a83a..8fbf9ad24 100644
--- a/database/database.pgsql
+++ b/database/database.pgsql
@@ -681,8 +681,11 @@ INSERT INTO blocks(module,delta,status) VALUES('user', '1', '1');
 --- Functions
 ---
 
-CREATE FUNCTION "greatest"(integer, integer) RETURNS integer AS '
+CREATE FUNCTION greatest(integer, integer) RETURNS integer AS '
 BEGIN
+  IF $2 IS NULL THEN
+    RETURN $1;
+  END IF;
   IF $1 > $2 THEN
     RETURN $1;
   END IF;
-- 
cgit v1.2.3