diff options
| author | Andrew Dolgov <[email protected]> | 2005-09-07 14:31:21 +0100 |
|---|---|---|
| committer | Andrew Dolgov <[email protected]> | 2005-09-07 14:31:21 +0100 |
| commit | 8158c57a8e3a40338045e0b809bca42f1e703ca5 (patch) | |
| tree | d47c8e8cb0132d037139c34d29c956fca9c8b318 /functions.php | |
| parent | 4b3dff6ed580a7c5aec8fb50467043962861e0e7 (diff) | |
update schema, more mysql work
Diffstat (limited to 'functions.php')
| -rw-r--r-- | functions.php | 8 |
1 files changed, 6 insertions, 2 deletions
diff --git a/functions.php b/functions.php index bea443c27..742e026f5 100644 --- 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 |