summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorDries Buytaert2005-11-24 19:56:33 (GMT)
committer Dries Buytaert2005-11-24 19:56:33 (GMT)
commitfd6a64324c6473b9462cfb1a36695039b9e6f922 (patch)
tree5cac97e81b989d8b5efbf77e08db32872c492539
parentb6701ddf3fb3f0af2ac119c11c0cd602d9fe804f (diff)
- Patch #37383 by Cvbge: fixed clash between greatest() functions from Drupal and postgresql 8.1.
-rw-r--r--database/database.pgsql4
1 files changed, 2 insertions, 2 deletions
diff --git a/database/database.pgsql b/database/database.pgsql
index b94c2b7..f767177 100644
--- a/database/database.pgsql
+++ b/database/database.pgsql
@@ -822,7 +822,7 @@ ALTER SEQUENCE menu_mid_seq RESTART 2;
--- 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;
@@ -834,7 +834,7 @@ BEGIN
END;
' LANGUAGE 'plpgsql';
-CREATE FUNCTION greatest(integer, integer, integer) RETURNS integer AS '
+CREATE FUNCTION "greatest"(integer, integer, integer) RETURNS integer AS '
SELECT greatest($1, greatest($2, $3));
' LANGUAGE 'sql';