diff options
| author | Andrew Dolgov <[email protected]> | 2008-04-21 05:53:19 +0100 |
|---|---|---|
| committer | Andrew Dolgov <[email protected]> | 2008-04-21 05:53:19 +0100 |
| commit | fc2b26a6a27d19ecbfbb2202fd35b37568c65181 (patch) | |
| tree | f9123f21920265535bfab4987d8aac674bbbbe08 /modules/pref-feeds.php | |
| parent | f8232151a0a4bdd430e928d742686a2330e99d68 (diff) | |
add workaround for psql 8.3 stricter typechecking on SUBSTRING() (refs #201)
Diffstat (limited to 'modules/pref-feeds.php')
| -rw-r--r-- | modules/pref-feeds.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/modules/pref-feeds.php b/modules/pref-feeds.php index 9b718ace6..43be1cbe3 100644 --- a/modules/pref-feeds.php +++ b/modules/pref-feeds.php @@ -804,7 +804,7 @@ if ($_GET["slat"] == "true") { $show_last_article_info = true; $show_last_article_checked = "checked"; - $show_last_article_qpart = ", (SELECT SUBSTRING(MAX(updated),1,16) FROM ttrss_user_entries, + $show_last_article_qpart = ", (SELECT ".SUBSTRING_FOR_DATE."(MAX(updated),1,16) FROM ttrss_user_entries, ttrss_entries WHERE ref_id = ttrss_entries.id AND feed_id = F1.id) AS last_article"; } else if ($feeds_sort == "last_article") { |