6 |
'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, |
'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, |
7 |
entry_title as label, |
entry_title as label, |
8 |
entry_authored_on as date, |
entry_authored_on as date, |
9 |
entry_modified_on as modified, |
case |
10 |
|
when entry_modified_on < ( entry_authored_on + '30 days' ) then entry_modified_on |
11 |
|
else entry_authored_on + '1 day' |
12 |
|
end as modified, |
13 |
author_email as author, |
author_email as author, |
14 |
entry_text as content, |
entry_text as content, |
15 |
date_part('year', entry_authored_on) as year, |
date_part('year', entry_authored_on) as year, |