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
+
+
+
+