From fc2b26a6a27d19ecbfbb2202fd35b37568c65181 Mon Sep 17 00:00:00 2001
From: Andrew Dolgov <fox@madoka.spb.ru>
Date: Mon, 21 Apr 2008 05:53:19 +0100
Subject: add workaround for psql 8.3 stricter typechecking on SUBSTRING()
 (refs #201)

---
 modules/pref-users.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'modules/pref-users.php')

diff --git a/modules/pref-users.php b/modules/pref-users.php
index 4872a0d8f..399fc5e1e 100644
--- a/modules/pref-users.php
+++ b/modules/pref-users.php
@@ -197,7 +197,7 @@
 
 		$result = db_query($link, "SELECT 
 				id,login,access_level,email,
-				SUBSTRING(last_login,1,16) as last_login
+				".SUBSTRING_FOR_DATE."(last_login,1,16) as last_login
 			FROM 
 				ttrss_users
 			ORDER BY $sort");
-- 
cgit v1.2.3