diff options
author | Andrew Dolgov <[email protected]> | 2008-01-24 18:54:36 +0100 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2008-01-24 18:54:36 +0100 |
commit | 2240601ccf4ff9e9a25a2bc71eb0d2d6f826c9ee (patch) | |
tree | dac1e7c575c34a1191ad6a7397d5661bef6fe1c1 /update_daemon_loop.php | |
parent | abfa57fdf00894a07f8c268c799ce9b225e5bc5b (diff) |
daemons: fix feed select query for PGSQL
Diffstat (limited to 'update_daemon_loop.php')
-rw-r--r-- | update_daemon_loop.php | 5 |
1 files changed, 2 insertions, 3 deletions
diff --git a/update_daemon_loop.php b/update_daemon_loop.php index 08fad1b97..4c13dedce 100644 --- a/update_daemon_loop.php +++ b/update_daemon_loop.php @@ -116,13 +116,12 @@ } if (DB_TYPE == "pgsql") { - $update_limit_qpart = "AND ttrss_feeds.last_updated < NOW() - INTERVAL '".(DAEMON_SLEEP_INTERVAL*2)." seconds'"; $update_limit_qpart = "AND (( ttrss_feeds.update_interval = 0 - AND ttrss_feeds.last_updated < NOW() - INTERVAL ttrss_user_prefs.value || ' minutes' + AND ttrss_feeds.last_updated < NOW() - CAST((ttrss_user_prefs.value || ' minutes') AS INTERVAL) ) OR ( ttrss_feeds.update_interval > 0 - AND ttrss_feeds.last_updated < NOW() - INTERVAL ttrss_feeds.update_interval || ' minutes' + AND ttrss_feeds.last_updated < NOW() - CAST((ttrss_feeds.update_interval || ' minutes') AS INTERVAL) ))"; } else { $update_limit_qpart = "AND (( |