From e9346b996d8a49f9438cf567ea9eb356b31f206a Mon Sep 17 00:00:00 2001
From: Max Kanat-Alexander <mkanat@bugzilla.org>
Date: Mon, 14 Feb 2011 12:29:09 -0800
Subject: Remove tabs and fix some formatting in Bugzilla::DB::Pg.

https://bugzilla.mozilla.org/show_bug.cgi?id=616981
---
 Bugzilla/DB/Pg.pm | 8 ++++----
 1 file changed, 4 insertions(+), 4 deletions(-)

(limited to 'Bugzilla')

diff --git a/Bugzilla/DB/Pg.pm b/Bugzilla/DB/Pg.pm
index f0a395900..386a67709 100644
--- a/Bugzilla/DB/Pg.pm
+++ b/Bugzilla/DB/Pg.pm
@@ -198,10 +198,10 @@ sub sql_string_until {
     # PostgreSQL does not permit a negative substring length; therefore we
     # use CASE to only perform the SUBSTRING operation when $substring can
     # be found withing $string.
-    return "CASE WHEN " . $self->sql_position($substring, $string)
-                        . " != 0 THEN SUBSTRING($string FROM 1 FOR "
-                        . $self->sql_position($substring, $string) . " - 1)"
-		        . " ELSE $string END";
+    my $position = $self->sql_position($substring, $string);
+    return "CASE WHEN $position != 0"
+             . " THEN SUBSTRING($string FROM 1 FOR $position - 1)"
+             . " ELSE $string END";
 }
 
 # Tell us whether or not a particular sequence exists in the DB.
-- 
cgit v1.2.3-24-g4f1b