--- sql/mt.sql 2008/10/25 15:38:03 36 +++ sql/mt.sql 2008/10/25 16:39:22 37 @@ -6,7 +6,10 @@ 'http://blog.rot13.org/' || date_part('year', entry_authored_on) || '/' || lpad(date_part('month', entry_authored_on)::text,2,'0') || '/' || entry_basename || '.html' as uri, entry_title as label, entry_authored_on as date, - entry_modified_on as modified, + case + when entry_modified_on < ( entry_authored_on + '30 days' ) then entry_modified_on + else entry_authored_on + '1 day' + end as modified, author_email as author, entry_text as content, date_part('year', entry_authored_on) as year,