powered by simpleCommunicator - 2.0.61     © 2026 Programmizd 02
Целевая тема:
Создать новую тему:
Автор:
Закрыть
Цитировать
Форумы / PostgreSQL [игнор отключен] [закрыт для гостей] / array_to_json
5 сообщений из 5, страница 1 из 1
array_to_json
    #38784357
VanillaNInja
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Гость
пытаюсь запихнуть массив json строчкой типа

Код: plsql
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[])



но вот наш любимый постгрес ругается на такое насилие "missing dimension value"
Вроде просьба логична, но вот не понятно куда ставить этот дименшн вэлью. Функция же принимает только массив и булево значение, которое никак не влияет на результат сией аферы.
...
Рейтинг: 0 / 0
array_to_json
    #38784406
V&N
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
V&N
Гость
где массив?
8.15.2. Array Value Input
...
Рейтинг: 0 / 0
array_to_json
    #38784408
Фотография Maxim Boguk
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
VanillaNInjaпытаюсь запихнуть массив json строчкой типа

Код: plsql
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[])



но вот наш любимый постгрес ругается на такое насилие "missing dimension value"
Вроде просьба логична, но вот не понятно куда ставить этот дименшн вэлью. Функция же принимает только массив и булево значение, которое никак не влияет на результат сией аферы.


оно ругается не при array_to_json
а при ''::text[]
из чего можно сделать вывод что массив вы на вход криво передаете
почитайте http://www.postgresql.org/docs/9.3/interactive/arrays.html#ARRAYS-INPUT

PS: и опять я вас к документации отправляю которую вы читать явно не пытаетесь даже :(
...
Рейтинг: 0 / 0
array_to_json
    #38784418
V&N
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
V&N
Гость
Код: plsql
1.
2.
select '[{"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":""}]
'::json
...
Рейтинг: 0 / 0
array_to_json
    #38784492
VanillaNInja
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Гость
Maxim Boguk,

Очередной раз спасибо!

Каюсь, виновен. Проблема кроется скорее не в нежелании читать документацию а непонимании того что именно там искать :-(
...
Рейтинг: 0 / 0
5 сообщений из 5, страница 1 из 1
Форумы / PostgreSQL [игнор отключен] [закрыт для гостей] / array_to_json
Найденые пользователи ...
Разблокировать пользователей ...
Читали форум (0):
Пользователи онлайн (0):
x
x
Закрыть


Просмотр
0 / 0
Close
Debug Console [Select Text]