/[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

Diff of /sql/mt.sql

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 33 by dpavlin, Sat Oct 25 12:02:49 2008 UTC revision 37 by dpavlin, Sat Oct 25 16:39:22 2008 UTC
# Line 6  select Line 6  select
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,
16          length(entry_text) as length          length(entry_text) as length_valueType_number
17  from mt_entry  from mt_entry
18  join mt_author on entry_author_id = author_id  join mt_author on entry_author_id = author_id
19  order by entry_authored_on desc  order by entry_authored_on desc
Legend:
Removed from v.33  
changed lines
  Added in v.37
  ViewVC Help
Powered by ViewVC 1.1.26