From 3a954ad47f909d62d0730482a07ceee11f853e6f Mon Sep 17 00:00:00 2001
From: moodler <moodler>
Date: Tue, 9 Mar 2004 12:46:03 +0000
Subject: [PATCH] Fix for PostgreSQL and user searching  Thanks Ulrik!  bug
 1101

---
 lib/datalib.php | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/lib/datalib.php b/lib/datalib.php
index 77b69a3adf..dbada50e50 100644
--- a/lib/datalib.php
+++ b/lib/datalib.php
@@ -1313,7 +1313,7 @@ function get_users($get=true, $search="", $confirmed=false, $exceptions="", $sor
              $LIKE = "LIKE";
              break;
         case "postgres7":
-             $fullname = " firstname||\" \"||lastname ";
+             $fullname = " firstname||' '||lastname ";
              $LIKE = "ILIKE";
              break;
         default: 
@@ -1365,7 +1365,7 @@ function get_users_listing($sort, $dir="ASC", $page=1, $recordsperpage=20, $sear
              break;
         case "postgres7":
              $limit = "LIMIT $recordsperpage OFFSET ".($page);
-             $fullname = " firstname||\" \"||lastname ";
+             $fullname = " firstname||' '||lastname ";
              $LIKE = "ILIKE";
              break;
         default: 
-- 
2.39.5