aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_delete_more_guest_inhouse_json
Parameters
Name
Type
Mode
p_data
jsonb
IN
Definition
declare result_json json; eff_result int; v_register_id integer; v_guest_id integer; v_arrival_date date; v_msg_text text; v_sqlstate text; v_detail text; v_hint text; v_context text; v_guests jsonb; begin if p_data is not null then v_register_id := (p_data ->> 'register_id') :: int4; v_guest_id := (p_data ->> 'guest_id') :: int4; v_arrival_date := (p_data ->> 'arrival_date') :: date; delete from register_guests where register_id = v_register_id and guest_id = v_guest_id; end if; result_json := (select * from sp_get_scan_inhouse_json( arrival_date := v_arrival_date )); return coalesce(result_json, '[]'::json); -- return fn_result_success(coalesce(result_json, '[]'::json)); exception when others then get stacked diagnostics v_msg_text = message_text, v_sqlstate = returned_sqlstate, v_detail = pg_exception_detail, v_hint = pg_exception_hint, v_context = pg_exception_context; return fn_handle_error( v_sqlstate, v_msg_text, v_detail, v_hint, v_context, 'sp_delete_more_guest_inhouse_json', null ); end;