From 8bb3cb2ac9f523b9f840b26624a74bd4e8c81de2 Mon Sep 17 00:00:00 2001 From: "mkanat%kerio.com" <> Date: Thu, 17 Mar 2005 14:54:05 +0000 Subject: Bug 286392: String concatenation on postgres does not always work Patch By Tomas Kopal r=mkanat, a=justdave --- Bugzilla/DB/Pg.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'Bugzilla/DB/Pg.pm') diff --git a/Bugzilla/DB/Pg.pm b/Bugzilla/DB/Pg.pm index de3260e7a..be921f4d1 100644 --- a/Bugzilla/DB/Pg.pm +++ b/Bugzilla/DB/Pg.pm @@ -137,7 +137,7 @@ sub sql_string_concat { # Postgres 7.3 does not support concatenating of different types, so we # need to cast both parameters to text. Version 7.4 seems to handle this # properly, so when we stop support 7.3, this can be removed. - return 'CAST(' . join(' AS text) || CAST(', @params) . ' AS text)'; + return '(CAST(' . join(' AS text) || CAST(', @params) . ' AS text))'; } sub bz_lock_tables { -- cgit v1.2.3-24-g4f1b