Changes between Version 20 and Version 21 of verfahrenUmstellung

Timestamp:

May 2, 2007, 3:31:01 PM (17 years ago)

Author:

casties

Comment:

--

verfahrenUmstellung

@@ -52 +52 @@
 {{{
 CREATE OR REPLACE VIEW personal_www_list AS 
- SELECT personal_www.last_name, personal_www.first_name, personal_www.status, personal_www.e_mail,
-  personal_www.telefon, personal_www.fax, personal_www.department, personal_www.id,
-  personal_www.e_mail_p, personal_www.telefon_p, personal_www.fax_p, personal_www.cv,
-  personal_www.awards, personal_www.image, personal_www.title, personal_www.date_stay_at_mpiwg,
-  personal_www.home_inst, personal_www.private_homepage, personal_www.publish_the_data,
-  personal_www.date_from, personal_www.date_to, personal_www.date_special_text,
-  personal_www.funded_by, personal_www.e_mail2, personal_www.id_zahl, personal_www.room_no,
-  personal_www.e_mail2_p, personal_www."key", personal_www.web_object_created, personal_www."group",
+ SELECT *,
   CASE
     WHEN personal_www."group" = 'Wissenschaftler'::text 
@@ -74 +67 @@
 {{{
 CREATE OR REPLACE VIEW personal_www_list AS 
- SELECT personal_www.last_name, personal_www.first_name, personal_www.status, personal_www.e_mail, personal_www.telefon, personal_www.fax, personal_www.department, personal_www.id, personal_www.e_mail_p, personal_www.telefon_p, personal_www.fax_p, personal_www.cv, personal_www.awards, personal_www.image, personal_www.title, personal_www.date_stay_at_mpiwg, personal_www.home_inst, personal_www.private_homepage, personal_www.publish_the_data, personal_www.date_from, personal_www.date_to, personal_www.date_special_text, personal_www.funded_by, personal_www.e_mail2, personal_www.id_zahl, personal_www.room_no, personal_www.e_mail2_p, personal_www."key", personal_www.web_object_created, personal_www."group", 
+ SELECT *, 
         CASE
             WHEN personal_www."group" = 'Wissenschaftler'::text OR personal_www."group" = 'wissenschaftliche Gäste'::text OR personal_www."group" = 'Stipendiaten'::text THEN 'yes'::text