/[simile]/sql/mt.sql
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Annotation of /sql/mt.sql

Parent Directory Parent Directory | Revision Log Revision Log


Revision 50 - (hide annotations)
Mon Nov 3 15:33:52 2008 UTC (15 years, 4 months ago) by dpavlin
File size: 687 byte(s)
make sure that id isn't null because Exhibit doesn't like it
1 dpavlin 33 \c blogs
2     -- Movable Type
3    
4     select
5 dpavlin 50 coalesce(entry_atom_id,entry_basename) as id,
6 dpavlin 33 '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     ;

  ViewVC Help
Powered by ViewVC 1.1.26