Index: openacs-4/packages/survey/www/admin/one-respondent-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/survey/www/admin/one-respondent-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/survey/www/admin/one-respondent-postgresql.xql 16 Sep 2002 00:00:24 -0000 1.1
+++ openacs-4/packages/survey/www/admin/one-respondent-postgresql.xql 10 Oct 2003 14:41:45 -0000 1.2
@@ -4,7 +4,7 @@
postgresql7.1
- select response_id, case when initial_response_id is NULL then 'T' else 'F' end as original_p, survey_response__initial_response_id(response_id) as initial_response, creation_date
+ select response_id, case when initial_response_id is NULL then 'T' else 'F' end as original_p, coalesce(initial_response_id,response_id) as initial_response, creation_date
from survey_responses, acs_objects
where response_id = object_id
and creation_user = :user_id