1.
2.
select array_to_json('[{"user":1,"userId":1,"case_type_id":"1","care_regimen_id":"1","id":"","clinic_id":"1600","talon":"","ak":"","patient_id":"","uid":"4004250","funding_id":"1","init_goal_id":"3","care_level_id":"6","payment_method_id":"102","admission_reason_id":"14","repeat_count_id":"1","main_diagnos_id":"","referral_id":"4004250","ref_organization_id":"6102231","recv_organization_id":"","ref_doctor_id":"4242","referral_date":"2014-10-01","order_number":"","referral_type_id":"9","sl_code":"4004250","disability_reason_id":"3","disability_from_dt":"2014-10-01","disability_to_dt":"2014-10-02","result_id":"","outcome_id":"","provision_condition_id":"","care_providing_from_id":"","visits":[{"nn":"1","step_num":1,"admission_date":"3878","doctor_id":"3878","type_id":"1","place_id":"2","goal_id":"2","profile_id":"75","standard_id":"","mes_id":"1","result_id":"","outcome_id":"","id":"","initiator_id":"","res_group_id":"","is_viewed":"","is_needed":"","is_sanitized":"","stom_code":""}],"diagnosis":[{"mkb_id":"23437","step_num":"","disease_type_id":"1","type_id":"1","stage_id":"1","is_main":"","id":"","step_id":"","disp_id":"","disp_in_out":"","nosol_registr_id":"","dispensary_group_id":"","reg_in_dt":"","reg_out_dt":"","reg_in_doctor_id":"","reg_out_doctor_id":"","reg_stage_id":"","reg_out_reason_id":""},{"mkb_id":"23437","step_num":1,"disease_type_id":"1","type_id":"1","stage_id":"1","is_main":"","id":"","step_id":"","disp_id":"","disp_in_out":"","nosol_registr_id":"","dispensary_group_id":"","reg_in_dt":"","reg_out_dt":"","reg_in_doctor_id":"","reg_out_doctor_id":"","reg_stage_id":"","reg_out_reason_id":""}],"services":[{"doctor_id":"3878","step_num":1,"service_id":"41494","funding_id":"1","quantity":"","mkb_id":"1","id":"","step_id":"","bdate":"","res_group_id":""}]},{"user":1,"userId":1,"case_type_id":"1","care_regimen_id":"1","service.quantity":"1","id":"","clinic_id":"1600","talon":"","ak":"","patient_id":"","uid":"","funding_id":"1","init_goal_id":"3","care_level_id":"6","payment_method_id":"102","admission_reason_id":"14","repeat_count_id":"1","main_diagnos_id":"","referral_id":"4004250","ref_organization_id":"6102231","recv_organization_id":"","ref_doctor_id":"4242","referral_date":"2014-10-01","order_number":"","referral_type_id":"9","sl_code":"4004250","disability_reason_id":"3","disability_from_dt":"2014-10-01","disability_to_dt":"2014-10-02","result_id":"","outcome_id":"","diagnosis.id":"","diagnosis.mkb_id":"","diagnosis.type_id":"","diagnosis.disease_type_id":"","diagnosis.is_main":"","diagnosis.stage_id":"","diagnosis.step_id":"","diagnosis.step_num":"","diagnosis.disp_id":"","diagnosis.disp_in_out":"","diagnosis.nosol_registr_id":"","diagnosis.dispensary_group_id":"","diagnosis.reg_in_dt":"","diagnosis.reg_out_dt":"","diagnosis.reg_in_doctor_id":"","diagnosis.reg_out_doctor_id":"","diagnosis.reg_stage_id":"","diagnosis.reg_out_reason_id":"","visits.id":"","visits.step_num":"","visits.nn":"","visits.type_id":"","visits.admission_date":"","visits.place_id":"","visits.initiator_id":"","visits.goal_id":"","visits.profile_id":"","visits.standard_id":"","visits.mes_id":"","visits.res_group_id":"","visits.result_id":"","visits.outcome_id":"","visits.doctor_id":"","visits.is_viewed":"","visits.is_needed":"","visits.is_sanitized":"","visits.stom_code":"","service.id":"","service.service_id":"","service.step_id":"","service.step_num":"","service.bdate":"","service.funding_id":"","service.res_group_id":"","service.mkb_id":"","service.doctor_id":"","provision_condition_id":"","care_providing_from_id":"","diagnosis1.mkb_id":"23437","diagnosis1.disease_type_id":"1","diagnosis1.type_id":"1","diagnosis1.stage_id":"1","diagnosis1.is_main":"","diagnosis1.id":"","diagnosis1.step_id":"","diagnosis1.step_num":"","diagnosis1.disp_id":"","diagnosis1.disp_in_out":"","diagnosis1.nosol_registr_id":"","diagnosis1.dispensary_group_id":"","diagnosis1.reg_in_dt":"","diagnosis1.reg_out_dt":"","diagnosis1.reg_in_doctor_id":"","diagnosis1.reg_out_doctor_id":"","diagnosis1.reg_stage_id":"","diagnosis1.reg_out_reason_id":"","visits1.nn":"1","visits1.admission_date":"3878","visits1.doctor_id":"3878","visits1.type_id":"1","visits1.place_id":"2","visits1.goal_id":"2","visits1.profile_id":"75","visits1.standard_id":"","visits1.mes_id":"1","visits1.result_id":"11","visits1.outcome_id":"","visits1.id":"","visits1.step_num":"","visits1.initiator_id":"","visits1.res_group_id":"","visits1.is_viewed":"","visits1.is_needed":"","visits1.is_sanitized":"","visits1.stom_code":"","service1.doctor_id":"3878","service1.service_id":"41494","service1.funding_id":"1","service1.quantity":"","service1.mkb_id":"1","service1.id":"","service1.step_id":"","service1.step_num":"","service1.bdate":"","service1.res_group_id":""}]
'::text[])