update schema, more mysql work

[tt-rss.git] / functions.php

diff --git a/functions.php b/functions.php
index bea443c2765d283ca445c7f253a549dfc84da8a1..742e026f5c54f01c63ef26c02451bc82299deb91 100644 (file)
--- a/functions.php
+++ b/functions.php
@@ -171,10 +171,14 @@
 
                                $entry_guid = db_escape_string($entry_guid);
 
+                               if (DB_TYPE == "pgsql") {
+                                       $extract_ts_qpart = ",EXTRACT(EPOCH FROM updated) as updated_timestamp";
+                               }
+
                                $result = db_query($link, "
                                        SELECT 
-                                               id,last_read,no_orig_date,title,feed_id,content_hash,
-                                               EXTRACT(EPOCH FROM updated) as updated_timestamp
+                                               id,last_read,no_orig_date,title,feed_id,content_hash
+                                               $extract_ts_qpart
                                        FROM
                                                ttrss_entries 
                                        WHERE