Index: openacs-4/packages/acs-subsite/sql/postgresql/acs-subsite-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/sql/postgresql/acs-subsite-create.sql,v
diff -u -r1.9 -r1.10
--- openacs-4/packages/acs-subsite/sql/postgresql/acs-subsite-create.sql	8 Dec 2009 01:57:22 -0000	1.9
+++ openacs-4/packages/acs-subsite/sql/postgresql/acs-subsite-create.sql	3 Sep 2024 15:37:33 -0000	1.10
@@ -17,25 +17,9 @@
 \i themes-create.sql
 
 -- DRB: user profiles are fundamentally broken, which is probably why they
--- weren't created in the original ACS 4.2 Oracle sources. 
+-- weren't created in the original ACS 4.2 Oracle sources.
 -- \i user-profiles-create.sql
 
--- This view lets us avoid using acs_object.name to get party_names.
--- 
--- create or replace view party_names
--- as
--- select p.party_id,
---        decode(groups.group_id,
---               null, decode(persons.person_id, 
---                            null, p.email,
---                            persons.first_names || ' ' || persons.last_name),
---               groups.group_name) as party_name
--- from parties p,
---      groups,
---      persons
--- where p.party_id = groups.group_id(+)
---   and p.party_id = persons.person_id(+);
-
 create view party_names
 as
 select p.party_id,
@@ -48,7 +32,7 @@
 	       persons.first_names || ' ' || persons.last_name
 	    end)
          else
-	   groups.group_name	    
+	   groups.group_name
        end) as party_name
 from ((parties p left outer join groups on p.party_id = groups.group_id)
       left outer join persons on p.party_id = persons.person_id);