Index: openacs-4/packages/ecommerce/sql/postgresql/ecommerce-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/sql/postgresql/ecommerce-create.sql,v diff -u -N -r1.20 -r1.21 --- openacs-4/packages/ecommerce/sql/postgresql/ecommerce-create.sql 9 Aug 2008 19:24:21 -0000 1.20 +++ openacs-4/packages/ecommerce/sql/postgresql/ecommerce-create.sql 28 Aug 2008 10:46:28 -0000 1.21 @@ -36,19 +36,7 @@ -- Helper stuff (ben@adida.net) -- gilbertw - I pulled this from OpenACS 3.2.5 -- there are a few calls to the Oracle least function -create function least(numeric,numeric) -returns numeric -as ' -DECLARE - first alias for $1; - second alias for $2; -BEGIN - if first < second - then return first; - else return second; - end if; -END; -' language 'plpgsql'; +-- least removed since now included with postgresql by default -- gilbertw -- timespan_days taken from OpenACS 3.2.5 Index: openacs-4/packages/ecommerce/sql/postgresql/ecommerce-drop.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/sql/postgresql/ecommerce-drop.sql,v diff -u -N -r1.9 -r1.10 --- openacs-4/packages/ecommerce/sql/postgresql/ecommerce-drop.sql 10 Aug 2008 02:52:13 -0000 1.9 +++ openacs-4/packages/ecommerce/sql/postgresql/ecommerce-drop.sql 28 Aug 2008 10:46:28 -0000 1.10 @@ -261,7 +261,7 @@ drop table ec_templates_audit; drop table ec_templates; drop function timespan_days(float); -drop function least(numeric,numeric); + drop view ec_template_id_sequence; drop sequence ec_template_id_seq;