From 1e59ae3582c48fd7a5e3b4853992afa1712da3a7 Mon Sep 17 00:00:00 2001
From: Andrew Dolgov <fox@madoka.spb.ru>
Date: Wed, 29 Mar 2006 04:43:21 +0100
Subject: fix purge_feed for pg 8.1, new option: PG_VERSION

---
 functions.php | 23 ++++++++++++++++++-----
 1 file changed, 18 insertions(+), 5 deletions(-)

(limited to 'functions.php')

diff --git a/functions.php b/functions.php
index dc894568f..8175a4326 100644
--- a/functions.php
+++ b/functions.php
@@ -24,15 +24,28 @@
 				(SELECT date_entered FROM ttrss_entries WHERE
 					id = ref_id) < NOW() - INTERVAL '$purge_interval days'"); */
 
-			$result = db_query($link, "DELETE FROM ttrss_user_entries WHERE 
-				ttrss_entries.id = ref_id AND 
-				marked = false AND 
-				feed_id = '$feed_id' AND 
-				ttrss_entries.date_entered < NOW() - INTERVAL '$purge_interval days'");
+			if (PG_VERSION == "7.4" || PG_VERSION == "8.0") {
+
+				$result = db_query($link, "DELETE FROM ttrss_user_entries WHERE 
+					ttrss_entries.id = ref_id AND 
+					marked = false AND 
+					feed_id = '$feed_id' AND 
+					ttrss_entries.date_entered < NOW() - INTERVAL '$purge_interval days'");
+
+			} else {
+
+				$result = db_query($link, "DELETE FROM ttrss_user_entries 
+					USING ttrss_entries 
+					WHERE ttrss_entries.id = ref_id AND 
+					marked = false AND 
+					feed_id = '$feed_id' AND 
+					ttrss_entries.date_entered < NOW() - INTERVAL '$purge_interval days')");
+			}
 
 			$rows = pg_affected_rows($result);
 			
 		} else {
+		
 /*			$result = db_query($link, "DELETE FROM ttrss_user_entries WHERE
 				marked = false AND feed_id = '$feed_id' AND
 				(SELECT date_entered FROM ttrss_entries WHERE 
-- 
cgit v1.2.3-54-g00ecf