diff options
author | Yorhel <git@yorhel.nl> | 2009-08-08 19:45:05 +0200 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2009-08-08 19:45:05 +0200 |
commit | 763cffca97e49d9908ff4d499cdca150bcad5670 (patch) | |
tree | 777b8343a6832a539607f0f9f07737cee26c6a88 /lib/Multi | |
parent | f95031507420e14ab95512b3bfbbbfab8fe5ce9f (diff) |
Converted tags.added to timestamptz
Diffstat (limited to 'lib/Multi')
-rw-r--r-- | lib/Multi/IRC.pm | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/lib/Multi/IRC.pm b/lib/Multi/IRC.pm index 84f307d9..8c5d4143 100644 --- a/lib/Multi/IRC.pm +++ b/lib/Multi/IRC.pm @@ -274,7 +274,7 @@ sub notify { # name, pid, payload 'g' AS type, t.id, t.name AS title, u.username FROM tags t JOIN users u ON u.id = t.addedby - WHERE t.added > ? + WHERE t.added > to_timestamp(?) ORDER BY t.added|; $_[KERNEL]->post(pg => query => $q, [ $t ], 'formatid', [ keys %{$_[HEAP]{notify}} ]); |