Index: openacs-4/packages/contacts/tcl/view-procs-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/contacts/tcl/Attic/view-procs-postgresql.xql,v diff -u -r1.3 -r1.3.2.1 --- openacs-4/packages/contacts/tcl/view-procs-postgresql.xql 27 Feb 2005 17:07:18 -0000 1.3 +++ openacs-4/packages/contacts/tcl/view-procs-postgresql.xql 30 Nov 2005 15:31:01 -0000 1.3.2.1 @@ -1,87 +1,85 @@ - - - -postgresql7.2 - - - - select sort_order - from contact_views - where contact_object_type = :contact_object_type - order by sort_order desc limit 1 - - - - - - - select contact__view_create( - null, - :src, - :privilege_required, - :privilege_object_id, - :contact_object_type, - :package_id, - :sort_order, - now(), - :creation_user, - :creation_ip, - :context_id) as view_id - - - - - - - select contact__view_name_save( - :view_id, - :locale, - :name - ) - - - - - - - select '1' from contact_views limit 1 - - - - - - - select package_id from apm_packages where package_key = 'contacts' - - - - - - - select 1 from contact_views where view_id = :view_id and contact_object_type = :object_type - - - - - - - select * - from contact_views - where view_id = :view_id - - - - - - - select name from contact_view_names where view_id = :view_id and locale = :locale - - - - - - select view_id from contact_views where contact_object_type = :object_type order by sort_order limit 1 - - - - + + + + + + select sort_order + from contact_views + where contact_object_type = :contact_object_type + order by sort_order desc limit 1 + + + + + + + select contact__view_create( + null, + :src, + :privilege_required, + :privilege_object_id, + :contact_object_type, + :package_id, + :sort_order, + now(), + :creation_user, + :creation_ip, + :context_id) as view_id + + + + + + + select contact__view_name_save( + :view_id, + :locale, + :name + ) + + + + + + + select '1' from contact_views limit 1 + + + + + + + select package_id from apm_packages where package_key = 'contacts' + + + + + + + select 1 from contact_views where view_id = :view_id and contact_object_type = :object_type + + + + + + + select * + from contact_views + where view_id = :view_id + + + + + + + select name from contact_view_names where view_id = :view_id and locale = :locale + + + + + + select view_id from contact_views where contact_object_type = :object_type order by sort_order limit 1 + + + +