Index: openacs-4/contrib/packages/survey/www/admin/predefined-question-2-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/survey/www/admin/Attic/predefined-question-2-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/contrib/packages/survey/www/admin/predefined-question-2-postgresql.xql	19 Sep 2003 16:48:04 -0000	1.1
+++ openacs-4/contrib/packages/survey/www/admin/predefined-question-2-postgresql.xql	23 Oct 2003 06:22:26 -0000	1.2
@@ -45,4 +45,14 @@
       </querytext>
 </fullquery>
 
+<fullquery name="add_new_choices"> 
+      <querytext>
+      insert into
+      survey_question_choices(choice_id,predef_choice_id,question_id,label,numeric_value,sort_order,presentation_alignment,more_info_type)
+      (select
+      nextval('survey_choice_id_sequence'),choice_id,:question_id,label,numeric_value,sort_order,presentation_alignment,more_info_type
+      from survey_predef_question_choices where question_id=:predefined_question_id)
+      </querytext>
+</fullquery>
+
 </queryset>