diff options
| author | Evan Prodromou <evan@controlyourself.ca> | 2009-03-11 22:43:55 -0400 |
|---|---|---|
| committer | Evan Prodromou <evan@controlyourself.ca> | 2009-03-11 22:43:55 -0400 |
| commit | 4a41dbcdc4ba61b8aa59f4d3cba545652e5706e1 (patch) | |
| tree | 231b0ec660ca779df89263dfd6bc3833064e454d /actions/sup.php | |
| parent | 254e5e502017dad767a6b57aa2c5c9422d6e02e5 (diff) | |
| parent | 2fa6d429776f60925717a7c18330c3df0cd9d124 (diff) | |
Merge branch '0.7.x' of git@gitorious.org:laconica/dev into 0.7.x
Diffstat (limited to 'actions/sup.php')
| -rw-r--r-- | actions/sup.php | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/actions/sup.php b/actions/sup.php index f4b1cda23..8ef9207fa 100644 --- a/actions/sup.php +++ b/actions/sup.php @@ -65,7 +65,9 @@ class SupAction extends Action $notice->query('SELECT profile_id, max(id) AS max_id ' . 'FROM notice ' . - 'WHERE created > (now() - ' . $seconds . ') ' . + ((common_config('db','type') == 'pgsql') ? + 'WHERE extract(epoch from created) > (extract(epoch from now()) - ' . $seconds . ') ' : + 'WHERE created > (now() - ' . $seconds . ') ' ) . 'GROUP BY profile_id'); $updates = array(); |