Index: openacs-4/packages/lars-blogger/sql/postgresql/upgrade/upgrade-1.0a3-1.0a4.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/lars-blogger/sql/postgresql/upgrade/Attic/upgrade-1.0a3-1.0a4.sql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/lars-blogger/sql/postgresql/upgrade/upgrade-1.0a3-1.0a4.sql	13 Dec 2003 20:02:28 -0000	1.2
+++ openacs-4/packages/lars-blogger/sql/postgresql/upgrade/upgrade-1.0a3-1.0a4.sql	14 Dec 2003 11:10:44 -0000	1.3
@@ -13,3 +13,11 @@
     constraint weblogger_ping_urls_pk
         primary key(package_id, ping_url)
 );
+
+
+-- Merge entry_date and posted_date column
+update pinds_blog_entries
+set    entry_date = to_timestamp(to_char(entry_date, 'YYYY-MM-DD') || ' ' || to_char(posted_date, 'HH24:MI:SS'), 'YYYY-MM-DD HH24:MI:SS');
+
+alter table pinds_blog_entries drop column posted_date;
+