Parent Directory | Revision Log | Patch
revision 37 by dpavlin, Sat Oct 25 16:39:22 2008 UTC | revision 50 by dpavlin, Mon Nov 3 15:33:52 2008 UTC | |
---|---|---|
# | Line 2 | Line 2 |
2 | -- Movable Type | -- Movable Type |
3 | ||
4 | select | select |
5 | entry_atom_id as id, | coalesce(entry_atom_id,entry_basename) 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, | '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, |
|
ViewVC Help | |
Powered by ViewVC 1.1.26 |