simile/sql/mt.sql

\c blogs
-- Movable Type

select
        entry_atom_id as id,
        '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,
        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,
        length(entry_text) as length_valueType_number
from mt_entry
join mt_author on entry_author_id = author_id
order by entry_authored_on desc
;
1	dpavlin	33	\c blogs
2			-- Movable Type
3
4			select
5			entry_atom_id as id,
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,
7			entry_title as label,
8			entry_authored_on as date,
9	dpavlin	37	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	dpavlin	33	author_email as author,
14			entry_text as content,
15			date_part('year', entry_authored_on) as year,
16	dpavlin	34	length(entry_text) as length_valueType_number
17	dpavlin	33	from mt_entry
18			join mt_author on entry_author_id = author_id
19			order by entry_authored_on desc
20			;