--- getfeed.sql	2007/03/15 10:26:22	1
+++ getfeed.sql	2007/03/15 10:31:41	2
@@ -24,15 +24,23 @@
 $$;
 
 create view my_feeds as
-select feed,title,substr(content,0,80),pubdate,link from getfeed('http://blog.rot13.org/index.xml')
+select feed,title,content,pubdate,link from getfeed('http://blog.rot13.org/index.xml')
 union
-select feed,title,substr(content,0,80),pubdate,link from getfeed('http://saturn.ffzg.hr/noauth/feed/workspace/rot13?category=Recent%20Changes;type=Atom')
+select feed,title,content,pubdate,link from getfeed('http://saturn.ffzg.hr/noauth/feed/workspace/rot13?category=Recent%20Changes;type=Atom')
 ;
 
 -- if your terminal isn't iso-8859-2, change this!
 set client_encoding  = 'iso-8859-2';
 
+-- materialize view
 select *
+into feeds
 from my_feeds
+;
+
+select
+	feed,title,substr(content,0,50),pubdate,link
+from feeds
 order by pubdate desc
-limit 10;
+limit 30
+;
