diff options
| author | Dries Buytaert <dries@buytaert.net> | 2005-11-27 10:52:30 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2005-11-27 10:52:30 +0000 |
| commit | debb7da318f3158c283a54428dc3f015b0577d69 (patch) | |
| tree | 44f550eedd307c1481d9c10d261d319945e99c83 | |
| parent | 679649baaa8f9c9b05af9dd3ca780553d155ef06 (diff) | |
| download | brdo-debb7da318f3158c283a54428dc3f015b0577d69.tar.gz brdo-debb7da318f3158c283a54428dc3f015b0577d69.tar.bz2 | |
- Patch #39019 by Cvbge: set search_path for functions in database.pgsql.
| -rw-r--r-- | database/database.pgsql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/database/database.pgsql b/database/database.pgsql index 1499e0bd6..c58b8c7e1 100644 --- a/database/database.pgsql +++ b/database/database.pgsql @@ -872,6 +872,9 @@ ALTER SEQUENCE menu_mid_seq RESTART 3; --- Functions --- +--- Always installed in 'public' as prefix isn't appended to function names +SET search_path TO public; + CREATE OR REPLACE FUNCTION "greatest"(numeric, numeric) RETURNS numeric AS ' SELECT CASE WHEN (($1 > $2) OR ($2 IS NULL)) THEN $1 ELSE $2 END; ' LANGUAGE 'sql'; |