Index: openacs-4/packages/calendar/www/views-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/www/Attic/views-postgresql.xql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/calendar/www/views-postgresql.xql	19 Feb 2004 17:58:37 -0000	1.3
+++ openacs-4/packages/calendar/www/views-postgresql.xql	27 Feb 2004 21:29:59 -0000	1.4
@@ -10,16 +10,17 @@
              coalesce(e.name, a.name) as name,
              coalesce(e.status_summary, a.status_summary) as status_summary,
              e.event_id as item_id,
-             (select type from cal_item_types where item_type_id= ci.item_type_id) as item_type,
+             cit.type as item_type,
              cals.calendar_id,
              cals.calendar_name
              $additional_select_clause
     from     acs_activities a,
              acs_events e,
              timespans s,
              time_intervals t,
-             cal_items ci,
-             calendars cals
+             calendars cals,
+             cal_items ci left join
+             cal_item_types cit on cit.item_type_id = ci.item_type_id
     where    e.timespan_id = s.timespan_id
     and      s.interval_id = t.interval_id
     and      e.activity_id = a.activity_id