Index: openacs-4/packages/calendar/tcl/cal-item-2-procs-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/tcl/Attic/cal-item-2-procs-postgresql.xql,v diff -u -N -r1.9 -r1.10 --- openacs-4/packages/calendar/tcl/cal-item-2-procs-postgresql.xql 23 May 2003 13:08:41 -0000 1.9 +++ openacs-4/packages/calendar/tcl/cal-item-2-procs-postgresql.xql 11 Aug 2003 12:14:15 -0000 1.10 @@ -17,11 +17,9 @@ select i.cal_item_id, 0 as n_attachments, - to_char(start_date, 'YYYY-MM-DD HH:MI:SS') as start_date, - end_date as end_date, - to_char(start_date, 'YYYY-MM-DD HH24:MI:SS') as ansi_start_date, - to_char(end_date, 'YYYY-MM-DD HH24:MI:SS') as ansi_end_date, - coalesce(e.name, a.name) as name, + to_char(start_date, 'YYYY-MM-DD HH24:MI:SS') as start_date_ansi, + to_char(end_date, 'YYYY-MM-DD HH24:MI:SS') as end_date_ansi, + coalesce(a.name, e.name) as name, coalesce(e.description, a.description) as description, recurrence_id, i.item_type_id, @@ -48,16 +46,8 @@ select i.cal_item_id, (select count(*) from attachments where object_id = cal_item_id) as n_attachments, - to_char(start_date,'HH:MIpm') as start_time, - to_char(start_date,'D') as day_of_week, - to_char(start_date,'Day') as pretty_day_of_week, - to_char(start_date,'DD') as day_of_month, - to_char(start_date, 'YYYY-MM-DD HH:MI:SS') as start_date, - to_char(start_date, 'MM/DD/YYYY') as pretty_short_start_date, - to_char(end_date, 'HH:MIpm') as end_time, - end_date as end_date, - to_char(start_date, 'YYYY-MM-DD HH24:MI:SS') as ansi_start_date, - to_char(end_date, 'YYYY-MM-DD HH24:MI:SS') as ansi_end_date, + to_char(start_date, 'YYYY-MM-DD HH24:MI:SS') as start_date_ansi, + to_char(end_date, 'YYYY-MM-DD HH24:MI:SS') as end_date_ansi, coalesce(a.name, e.name) as name, coalesce(e.description, a.description) as description, recurrence_id,