Index: openacs-4/packages/acs-automated-testing/sql/postgresql/acs-automated-testing-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-automated-testing/sql/postgresql/acs-automated-testing-create.sql,v diff -u -N -r1.1 -r1.1.4.1 --- openacs-4/packages/acs-automated-testing/sql/postgresql/acs-automated-testing-create.sql 11 Nov 2001 18:03:52 -0000 1.1 +++ openacs-4/packages/acs-automated-testing/sql/postgresql/acs-automated-testing-create.sql 1 Mar 2003 21:20:40 -0000 1.1.4.1 @@ -27,7 +27,7 @@ testcase_id varchar(512), package_key varchar(100), test_id integer, - timestamp timestamp, + timestamp timestamptz, result varchar(4), notes varchar(2000) ); @@ -36,7 +36,7 @@ create table aa_test_final_results ( testcase_id varchar(512), package_key varchar(100), - timestamp timestamp, + timestamp timestamptz, passes integer, fails integer ); Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql,v diff -u -N -r1.36.2.5 -r1.36.2.6 --- openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql 6 Feb 2003 16:49:09 -0000 1.36.2.5 +++ openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql 1 Mar 2003 21:21:20 -0000 1.36.2.6 @@ -452,7 +452,7 @@ cr_items on delete cascade, title varchar(1000), description text, - publish_date timestamp, + publish_date timestamptz, mime_type varchar(200) default 'text/plain' constraint cr_revisions_mime_type_ref references cr_mime_types, @@ -696,7 +696,7 @@ new_revision integer, old_status varchar(40), new_status varchar(40), - publish_date timestamp + publish_date timestamptz constraint cr_item_publish_audit_date_nil not null ); @@ -714,12 +714,12 @@ references cr_items constraint cr_release_periods_pk primary key, - start_when timestamp default now(), - end_when timestamp default now() + interval '20 years' + start_when timestamptz default current_timestamp, + end_when timestamptz default current_timestamp + interval '20 years' ); create table cr_scheduled_release_log ( - exec_date timestamp default now() not null, + exec_date timestamptz default current_timestamp not null, items_released integer not null, items_expired integer not null, err_num integer, @@ -733,7 +733,7 @@ create table cr_scheduled_release_job ( job_id integer, - last_exec timestamp + last_exec timestamptz ); comment on table cr_scheduled_release_job is ' Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-extlink.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-extlink.sql,v diff -u -N -r1.7.4.1 -r1.7.4.2 --- openacs-4/packages/acs-content-repository/sql/postgresql/content-extlink.sql 21 Jan 2003 13:45:03 -0000 1.7.4.1 +++ openacs-4/packages/acs-content-repository/sql/postgresql/content-extlink.sql 1 Mar 2003 21:21:20 -0000 1.7.4.2 @@ -12,7 +12,7 @@ -- create or replace package body content_extlink -- function new -create function content_extlink__new (varchar,varchar,varchar,varchar,integer,integer,timestamp with time zone,integer,varchar) +create function content_extlink__new (varchar,varchar,varchar,varchar,integer,integer,timestamptz,integer,varchar) returns integer as ' declare new__name alias for $1; -- default null Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-folder.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-folder.sql,v diff -u -N -r1.20.4.1 -r1.20.4.2 --- openacs-4/packages/acs-content-repository/sql/postgresql/content-folder.sql 21 Jan 2003 13:45:03 -0000 1.20.4.1 +++ openacs-4/packages/acs-content-repository/sql/postgresql/content-folder.sql 1 Mar 2003 21:21:20 -0000 1.20.4.2 @@ -33,7 +33,7 @@ end;' language 'plpgsql'; -- function new -create function content_folder__new (varchar,varchar,varchar,integer,integer,integer,timestamp with time zone,integer,varchar) +create function content_folder__new (varchar,varchar,varchar,integer,integer,integer,timestamptz,integer,varchar) returns integer as ' declare new__name alias for $1; @@ -115,7 +115,7 @@ -- function new -- accepts security_inherit_p DaveB -create function content_folder__new (varchar,varchar,varchar,integer,integer,integer,timestamp with time zone,integer,varchar, boolean) +create function content_folder__new (varchar,varchar,varchar,integer,integer,integer,timestamptz,integer,varchar, boolean) returns integer as ' declare new__name alias for $1; Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-image-drop.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-image-drop.sql,v diff -u -N -r1.3 -r1.3.4.1 --- openacs-4/packages/acs-content-repository/sql/postgresql/content-image-drop.sql 15 Nov 2001 01:47:13 -0000 1.3 +++ openacs-4/packages/acs-content-repository/sql/postgresql/content-image-drop.sql 1 Mar 2003 21:21:20 -0000 1.3.4.1 @@ -12,13 +12,13 @@ drop function image__delete (integer); -drop function image__new (varchar,integer,integer,integer,varchar,integer,varchar,integer,varchar,varchar,boolean,timestamp,varchar,integer,integer,integer); +drop function image__new (varchar,integer,integer,integer,varchar,integer,varchar,integer,varchar,varchar,boolean,timestamptz,varchar,integer,integer,integer); -drop function image__new_revision(integer, integer, varchar, varchar, timestamp, varchar, varchar, +drop function image__new_revision(integer, integer, varchar, varchar, timestamptz, varchar, varchar, integer, varchar, integer, integer); drop function image__new (varchar,integer,integer,integer,varchar,varchar,varchar,varchar,varchar,varchar,varchar, - varchar,timestamp,integer, integer); + varchar,timestamptz,integer, integer); begin; select content_type__unregister_mime_type( Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-image.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-image.sql,v diff -u -N -r1.7.2.3 -r1.7.2.4 --- openacs-4/packages/acs-content-repository/sql/postgresql/content-image.sql 6 Feb 2003 12:54:54 -0000 1.7.2.3 +++ openacs-4/packages/acs-content-repository/sql/postgresql/content-image.sql 1 Mar 2003 21:21:20 -0000 1.7.2.4 @@ -104,7 +104,7 @@ -- The Oracle version does allow a non-image type to be specified, as does my -- alternative down below. This needs a little more straightening out. -create function image__new (varchar,integer,integer,integer,varchar,integer,varchar,varchar,varchar,varchar,boolean,timestamp with time zone,varchar,integer,integer,integer +create function image__new (varchar,integer,integer,integer,varchar,integer,varchar,varchar,varchar,varchar,boolean,timestamptz,varchar,integer,integer,integer ) returns integer as ' declare new__name alias for $1; @@ -126,7 +126,7 @@ new__locale varchar default null; new__nls_language varchar default null; - new__creation_date timestamp default now(); + new__creation_date timestamptz default current_timestamp; new__context_id integer; v_item_id cr_items.item_id%TYPE; @@ -199,7 +199,7 @@ -- DRB's version create function image__new (varchar,integer,integer,integer,varchar,integer,varchar,varchar,varchar,varchar,varchar, - varchar,timestamp,integer, integer) returns integer as ' + varchar,timestamptz,integer, integer) returns integer as ' declare p_name alias for $1; p_parent_id alias for $2; -- default null @@ -268,7 +268,7 @@ return v_item_id; end; ' language 'plpgsql'; -create function image__new_revision(integer, integer, varchar, varchar, timestamp with time zone, varchar, varchar, +create function image__new_revision(integer, integer, varchar, varchar, timestamptz, varchar, varchar, integer, varchar, integer, integer) returns integer as ' declare p_item_id alias for $1; Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-item.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-item.sql,v diff -u -N -r1.39.2.2 -r1.39.2.3 --- openacs-4/packages/acs-content-repository/sql/postgresql/content-item.sql 27 Feb 2003 13:44:55 -0000 1.39.2.2 +++ openacs-4/packages/acs-content-repository/sql/postgresql/content-item.sql 1 Mar 2003 21:21:20 -0000 1.39.2.3 @@ -54,7 +54,7 @@ -- function new -create function content_item__new (varchar,integer,integer,varchar,timestamp with time zone,integer,integer,varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar) +create function content_item__new (varchar,integer,integer,varchar,timestamptz,integer,integer,varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar) returns integer as ' declare new__name alias for $1; @@ -212,7 +212,7 @@ end;' language 'plpgsql'; -create function content_item__new (varchar,integer,integer,varchar,timestamp with time zone,integer,integer,varchar,varchar,varchar,varchar,varchar,varchar,varchar,integer) +create function content_item__new (varchar,integer,integer,varchar,timestamptz,integer,integer,varchar,varchar,varchar,varchar,varchar,varchar,varchar,integer) returns integer as ' declare new__name alias for $1; @@ -416,7 +416,7 @@ -- function new -- sets security_inherit_p to FALSE -DaveB -create function content_item__new ( integer, varchar, integer, varchar, timestamp with time zone, integer, integer, varchar, boolean, varchar, text, varchar, boolean, varchar,varchar,varchar) +create function content_item__new ( integer, varchar, integer, varchar, timestamptz, integer, integer, varchar, boolean, varchar, text, varchar, boolean, varchar,varchar,varchar) returns integer as ' declare @@ -1605,7 +1605,7 @@ -- procedure set_release_period -create function content_item__set_release_period (integer, timestamp with time zone, timestamp with time zone) +create function content_item__set_release_period (integer, timestamptz, timestamptz) returns integer as ' declare set_release_period__item_id alias for $1; @@ -1984,7 +1984,7 @@ -- function get_publish_date create function content_item__get_publish_date (integer,boolean) -returns timestamp as ' +returns timestamptz as ' declare get_publish_date__item_id alias for $1; get_publish_date__is_live alias for $2; -- default ''f'' Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-keyword.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-keyword.sql,v diff -u -N -r1.10.4.3 -r1.10.4.4 --- openacs-4/packages/acs-content-repository/sql/postgresql/content-keyword.sql 27 Feb 2003 14:16:03 -0000 1.10.4.3 +++ openacs-4/packages/acs-content-repository/sql/postgresql/content-keyword.sql 1 Mar 2003 21:21:20 -0000 1.10.4.4 @@ -91,7 +91,7 @@ -- function new -create function content_keyword__new (varchar,varchar,integer,integer,timestamp with time zone,integer,varchar,varchar) +create function content_keyword__new (varchar,varchar,integer,integer,timestamptz,integer,varchar,varchar) returns integer as ' declare new__heading alias for $1; Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-revision.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-revision.sql,v diff -u -N -r1.29.4.1 -r1.29.4.2 --- openacs-4/packages/acs-content-repository/sql/postgresql/content-revision.sql 21 Jan 2003 13:45:03 -0000 1.29.4.1 +++ openacs-4/packages/acs-content-repository/sql/postgresql/content-revision.sql 1 Mar 2003 21:21:20 -0000 1.29.4.2 @@ -13,7 +13,7 @@ -- create or replace package body content_revision -- function new -create function content_revision__new (varchar,varchar,timestamp with time zone,varchar,varchar,integer,integer,integer,timestamp with time zone,integer,varchar) +create function content_revision__new (varchar,varchar,timestamptz,varchar,varchar,integer,integer,integer,timestamptz,integer,varchar) returns integer as ' declare new__title alias for $1; @@ -65,7 +65,7 @@ end;' language 'plpgsql'; -create function content_revision__new(varchar,varchar,timestamp with time zone,varchar,text,integer) returns integer as ' +create function content_revision__new(varchar,varchar,timestamptz,varchar,text,integer) returns integer as ' declare new__title alias for $1; new__description alias for $2; -- default null @@ -89,7 +89,7 @@ end;' language 'plpgsql'; -create function content_revision__new (varchar,varchar,timestamp with time zone,varchar,varchar,text,integer,integer,timestamp with time zone,integer,varchar) +create function content_revision__new (varchar,varchar,timestamptz,varchar,varchar,text,integer,integer,timestamptz,integer,varchar) returns integer as ' declare new__title alias for $1; @@ -120,7 +120,7 @@ end;' language 'plpgsql'; -- function new -create function content_revision__new (varchar,varchar,timestamp with time zone,varchar,varchar,text,integer,integer,timestamp with time zone,integer,varchar,integer) +create function content_revision__new (varchar,varchar,timestamptz,varchar,varchar,text,integer,integer,timestamptz,integer,varchar,integer) returns integer as ' declare new__title alias for $1; Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-schedule.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-schedule.sql,v diff -u -N -r1.7 -r1.7.4.1 --- openacs-4/packages/acs-content-repository/sql/postgresql/content-schedule.sql 13 May 2001 04:41:01 -0000 1.7 +++ openacs-4/packages/acs-content-repository/sql/postgresql/content-schedule.sql 1 Mar 2003 21:21:20 -0000 1.7.4.1 @@ -31,8 +31,8 @@ create function cr_scheduled_release_exec () returns integer as ' declare - exec__last_exec timestamp; - exec__this_exec timestamp default now(); + exec__last_exec timestamptz; + exec__this_exec timestamptz default current_timestamp; exec__items_released integer default 0; exec__items_expired integer default 0; exec__err_num integer; -- sqlcode Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-symlink.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-symlink.sql,v diff -u -N -r1.9.4.1 -r1.9.4.2 --- openacs-4/packages/acs-content-repository/sql/postgresql/content-symlink.sql 21 Jan 2003 13:45:03 -0000 1.9.4.1 +++ openacs-4/packages/acs-content-repository/sql/postgresql/content-symlink.sql 1 Mar 2003 21:21:20 -0000 1.9.4.2 @@ -12,7 +12,7 @@ -- create or replace package body content_symlink -- function new -create function content_symlink__new (varchar,varchar,integer,integer,integer,timestamp with time zone,integer,varchar) +create function content_symlink__new (varchar,varchar,integer,integer,integer,timestamptz,integer,varchar) returns integer as ' declare new__name alias for $1; -- default null Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-template.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-template.sql,v diff -u -N -r1.6.4.1 -r1.6.4.2 --- openacs-4/packages/acs-content-repository/sql/postgresql/content-template.sql 21 Jan 2003 13:45:03 -0000 1.6.4.1 +++ openacs-4/packages/acs-content-repository/sql/postgresql/content-template.sql 1 Mar 2003 21:21:20 -0000 1.6.4.2 @@ -35,7 +35,7 @@ end;' language 'plpgsql'; -- function new -create function content_template__new (varchar,integer,integer,timestamp with time zone,integer,varchar) +create function content_template__new (varchar,integer,integer,timestamptz,integer,varchar) returns integer as ' declare new__name alias for $1; Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-update.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-update.sql,v diff -u -N -r1.5.4.1 -r1.5.4.2 --- openacs-4/packages/acs-content-repository/sql/postgresql/content-update.sql 21 Jan 2003 13:45:03 -0000 1.5.4.1 +++ openacs-4/packages/acs-content-repository/sql/postgresql/content-update.sql 1 Mar 2003 21:21:20 -0000 1.5.4.2 @@ -167,8 +167,8 @@ references cr_items constraint cr_release_periods_pk primary key, - start_when timestamp default now(), - end_when timestamp default now() + interval ''20 years'' + start_when timestamptz default current_timestamp, + end_when timestamptz default current_timestamp + interval ''20 years'' )''; end if; @@ -179,7 +179,7 @@ execute '' create table cr_scheduled_release_log ( - exec_date timestamp default now() not null, + exec_date timestamptz default current_timestamp not null, items_released integer not null, items_expired integer not null, err_num integer, @@ -195,7 +195,7 @@ execute '' create table cr_scheduled_release_job ( job_id integer, - last_exec timestamp + last_exec timestamptz )''; execute '' Index: openacs-4/packages/acs-events/sql/postgresql/acs-events-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-events/sql/postgresql/acs-events-create.sql,v diff -u -N -r1.5 -r1.5.2.1 --- openacs-4/packages/acs-events/sql/postgresql/acs-events-create.sql 13 Aug 2002 19:03:33 -0000 1.5 +++ openacs-4/packages/acs-events/sql/postgresql/acs-events-create.sql 1 Mar 2003 21:21:49 -0000 1.5.2.1 @@ -451,7 +451,7 @@ integer, -- acs_events.activity_id%TYPE, integer, -- acs_events.recurrence_id%TYPE, varchar, -- acs_object_types.object_type%TYPE, - timestamp, -- acs_objects.creation_date%TYPE, + timestamptz, -- acs_objects.creation_date%TYPE, integer, -- acs_objects.creation_user%TYPE, varchar, -- acs_objects.creation_ip%TYPE, integer -- acs_objects.context_id%TYPE, @@ -741,16 +741,16 @@ create function acs_event__recurrence_timespan_edit ( integer, - timestamp, - timestamp + timestamptz, + timestamptz ) returns integer as ' DECLARE p_event_id alias for $1; p_start_date alias for $2; p_end_date alias for $3; v_timespan RECORD; - v_one_start_date timestamp; - v_one_end_date timestamp; + v_one_start_date timestamptz; + v_one_end_date timestamptz; BEGIN -- get the initial offsets select start_date, @@ -1064,7 +1064,7 @@ -- @return 0 (procedure dummy) -- integer, -- acs_events.event_id%TYPE, - timestamp -- default null + timestamptz -- default null ) returns integer as ' declare @@ -1076,14 +1076,14 @@ v_interval_name recurrence_interval_types.interval_name%TYPE; v_n_intervals recurrences.every_nth_interval%TYPE; v_days_of_week recurrences.days_of_week%TYPE; - v_last_date_done timestamp; - v_stop_date timestamp; - v_start_date timestamp; - v_event_date timestamp; + v_last_date_done timestamptz; + v_stop_date timestamptz; + v_start_date timestamptz; + v_event_date timestamptz; v_diff integer; - v_current_date timestamp; - v_last_day timestamp; - v_week_date timestamp; + v_current_date timestamptz; + v_last_day timestamptz; + v_week_date timestamptz; v_instance_count integer; v_days_length integer; v_days_index integer; Index: openacs-4/packages/acs-events/sql/postgresql/activity-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-events/sql/postgresql/activity-create.sql,v diff -u -N -r1.2 -r1.2.4.1 --- openacs-4/packages/acs-events/sql/postgresql/activity-create.sql 8 Mar 2002 22:30:11 -0000 1.2 +++ openacs-4/packages/acs-events/sql/postgresql/activity-create.sql 1 Mar 2003 21:21:49 -0000 1.2.4.1 @@ -173,7 +173,7 @@ boolean, -- in acs_activities.html_p%TYPE text, -- in acs_activities.status_summary%TYPE varchar, -- in acs_object_types.object_type%TYPE - timestamp, -- in acs_objects.creation_date%TYPE + timestamptz, -- in acs_objects.creation_date%TYPE integer, -- in acs_objects.creation_user%TYPE varchar, -- in acs_objects.creation_ip%TYPE integer -- in acs_objects.context_id%TYPE Index: openacs-4/packages/acs-events/sql/postgresql/oracle-compat-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-events/sql/postgresql/oracle-compat-create.sql,v diff -u -N -r1.2.2.1 -r1.2.2.2 --- openacs-4/packages/acs-events/sql/postgresql/oracle-compat-create.sql 21 Jan 2003 13:45:30 -0000 1.2.2.1 +++ openacs-4/packages/acs-events/sql/postgresql/oracle-compat-create.sql 1 Mar 2003 21:21:49 -0000 1.2.2.2 @@ -101,10 +101,10 @@ -- -- @return The date of the next weekday that is later than somedate -- - timestamp, -- somedate + timestamptz, -- somedate varchar -- weekday ) -returns timestamp as ' +returns timestamptz as ' declare next_day__somedate alias for $1; next_day__weekday alias for $2; @@ -143,10 +143,10 @@ -- -- @return The date plus n_months full months -- - timestamp, + timestamptz, integer ) -returns timestamp as ' +returns timestamptz as ' declare add_months__somedate alias for $1; add_months__n_months alias for $2; @@ -167,15 +167,15 @@ -- -- @return The last day of the month containing somedate -- - timestamp + timestamptz ) -returns timestamp as ' +returns timestamptz as ' declare last_day__somedate alias for $1; v_month integer; v_targetmonth integer; - v_date timestamp; - v_targetdate timestamp; + v_date timestamptz; + v_targetdate timestamptz; begin -- Initial values Index: openacs-4/packages/acs-events/sql/postgresql/oracle-compat-drop.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-events/sql/postgresql/oracle-compat-drop.sql,v diff -u -N -r1.1 -r1.1.4.1 --- openacs-4/packages/acs-events/sql/postgresql/oracle-compat-drop.sql 13 Jul 2001 02:48:51 -0000 1.1 +++ openacs-4/packages/acs-events/sql/postgresql/oracle-compat-drop.sql 1 Mar 2003 21:21:49 -0000 1.1.4.1 @@ -8,8 +8,8 @@ -- $Id$ drop function dow_to_int(varchar); -drop function next_day(timestamp,varchar); -drop function add_months(timestamp,integer); -drop function last_day(timestamp); +drop function next_day(timestamptz,varchar); +drop function add_months(timestamptz,integer); +drop function last_day(timestamptz); drop function to_interval(integer,varchar); Index: openacs-4/packages/acs-events/sql/postgresql/recurrence-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-events/sql/postgresql/recurrence-create.sql,v diff -u -N -r1.1 -r1.1.4.1 --- openacs-4/packages/acs-events/sql/postgresql/recurrence-create.sql 13 Jul 2001 02:51:01 -0000 1.1 +++ openacs-4/packages/acs-events/sql/postgresql/recurrence-create.sql 1 Mar 2003 21:21:49 -0000 1.1.4.1 @@ -65,7 +65,7 @@ -- Indicates when this event should stop recurring. Null indicates -- recur indefinitely. -- - recur_until timestamp, + recur_until timestamptz, -- -- Recurring events can be only partially populated if fully populating -- the events would require inserting too many instances. This @@ -75,7 +75,7 @@ -- then this column will always be prior to or the same as recur_until. -- This column will be null until some recurrences have been added. -- - db_populated_until timestamp, + db_populated_until timestamptz, -- -- This column holds the name of a PL/SQL function that will be called -- to generate dates of recurrences if interval_type is 'custom' @@ -140,7 +140,7 @@ varchar, -- recurrence_interval_types.interval_name%TYPE, integer, -- recurrences.every_nth_interval%TYPE, varchar, -- recurrences.days_of_week%TYPE default null, - timestamp, -- recurrences.recur_until%TYPE default null, + timestamptz, -- recurrences.recur_until%TYPE default null, varchar -- recurrences.custom_func%TYPE default null ) returns integer as ' -- recurrences.recurrence_id%TYPE Index: openacs-4/packages/acs-events/sql/postgresql/timespan-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-events/sql/postgresql/timespan-create.sql,v diff -u -N -r1.1 -r1.1.4.1 --- openacs-4/packages/acs-events/sql/postgresql/timespan-create.sql 13 Jul 2001 03:13:29 -0000 1.1 +++ openacs-4/packages/acs-events/sql/postgresql/timespan-create.sql 1 Mar 2003 21:21:49 -0000 1.1.4.1 @@ -24,8 +24,8 @@ interval_id integer constraint time_intervals_pk primary key, - start_date timestamp, - end_date timestamp, + start_date timestamptz, + end_date timestamptz, constraint time_interval_date_order_ck check(start_date <= end_date) ); @@ -59,8 +59,8 @@ -- -- @return id of new time interval -- - timestamp, -- time_intervals.start_date%TYPE default null, - timestamp -- time_intervals.end_date%TYPE default null + timestamptz, -- time_intervals.start_date%TYPE default null, + timestamptz -- time_intervals.end_date%TYPE default null ) returns integer as ' -- time_intervals.interval_id%TYPE declare @@ -120,8 +120,8 @@ -- @return 0 (procedure dummy) -- integer, -- time_intervals.interval_id%TYPE, - timestamp, -- time_intervals.start_date%TYPE default null, - timestamp -- time_intervals.end_date%TYPE default null + timestamptz, -- time_intervals.start_date%TYPE default null, + timestamptz -- time_intervals.end_date%TYPE default null ) returns integer as ' declare @@ -252,10 +252,10 @@ declare overlaps_p__interval_id_1 alias for $1; overlaps_p__interval_id_2 alias for $2; - v_start_1 timestamp; - v_start_2 timestamp; - v_end_1 timestamp; - v_end_2 timestamp; + v_start_1 timestamptz; + v_start_2 timestamptz; + v_end_1 timestamptz; + v_end_2 timestamptz; begin -- Pull out the start and end dates and call the main overlaps_p. select start_date, end_date @@ -291,8 +291,8 @@ -- @return true if the interval bounded by start_date through end_date, false otherwise. -- integer, -- time_intervals.interval_id%TYPE, - timestamp, -- time_intervals.start_date%TYPE default null, - timestamp -- time_intervals.end_date%TYPE default null + timestamptz, -- time_intervals.start_date%TYPE default null, + timestamptz -- time_intervals.end_date%TYPE default null ) returns boolean as ' declare @@ -331,10 +331,10 @@ -- -- @return true if intervals overlap, otherwise false. -- - timestamp, -- time_intervals.start_date%TYPE, - timestamp, -- time_intervals.end_date%TYPE, - timestamp, -- time_intervals.start_date%TYPE, - timestamp -- time_intervals.end_date%TYPE + timestamptz, -- time_intervals.start_date%TYPE, + timestamptz, -- time_intervals.end_date%TYPE, + timestamptz, -- time_intervals.start_date%TYPE, + timestamptz -- time_intervals.end_date%TYPE ) returns boolean as ' declare @@ -692,8 +692,8 @@ -- -- @return Id of new timespan -- - timestamp, -- time_intervals.start_date%TYPE default null, - timestamp -- time_intervals.end_date%TYPE default null + timestamptz, -- time_intervals.start_date%TYPE default null, + timestamptz -- time_intervals.end_date%TYPE default null ) returns integer as ' -- timespans.timespan_id%TYPE declare @@ -801,8 +801,8 @@ -- @return Id of interval being joined -- integer, -- timespans.timespan_id%TYPE, - timestamp, -- time_intervals.start_date%TYPE - timestamp -- time_intervals.end_date%TYPE + timestamptz, -- time_intervals.start_date%TYPE + timestamptz -- time_intervals.end_date%TYPE ) returns integer as ' -- time_intervals.interval_id%TYPE declare @@ -984,8 +984,8 @@ declare overlaps_interval_p__timespan_id alias for $1; overlaps_interval_p__interval_id alias for $2; -- default null - v_start_date timestamp; - v_end_date timestamp; + v_start_date timestamptz; + v_end_date timestamptz; begin select start_date, end_date into v_start_date, v_end_date @@ -1057,8 +1057,8 @@ -- @return true if interval with start and end dates overlaps with second timespan, otherwise false. -- integer, -- timespans.timespan_id%TYPE, - timestamp, -- time_intervals.start_date%TYPE - timestamp -- time_intervals.end_date%TYPE + timestamptz, -- time_intervals.start_date%TYPE + timestamptz -- time_intervals.end_date%TYPE ) returns boolean as ' declare