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)

---
 backend.php | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

(limited to 'backend.php')

diff --git a/backend.php b/backend.php
index a7606c5b7..47c5529cd 100644
--- a/backend.php
+++ b/backend.php
@@ -359,11 +359,11 @@
 			print "<div class='infoBoxContents'>";
 
 			$result = db_query($link, "SELECT login,
-				SUBSTRING(last_login,1,16) AS last_login,
+				".SUBSTRING_FOR_DATE."(last_login,1,16) AS last_login,
 				access_level,
 				(SELECT COUNT(int_id) FROM ttrss_user_entries 
 					WHERE owner_uid = id) AS stored_articles,
-				SUBSTRING(created,1,16) AS created
+				".SUBSTRING_FOR_DATE."(created,1,16) AS created
 				FROM ttrss_users 
 				WHERE id = '$uid'");
 				
-- 
cgit v1.2.3-54-g00ecf