add batch remove batch split batch show hidden batches hide batch
db<>fiddle
feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
2 rows affected
1 rows affected
id_medico fecha_inicial fecha_final
1 2021-04-22 08:00:00 2021-04-22 10:00:00
1 2021-04-22 13:00:00 2021-04-22 14:00:00
2 2021-04-22 08:00:00 2021-04-22 10:00:00
ERROR:  conflicting key value violates exclusion constraint "tbl_id_medico_tsrange_excl"
DETAIL:  Key (id_medico, tsrange(fecha_inicial, fecha_final))=(1, ["2021-04-22 07:00:00","2021-04-22 09:00:00")) conflicts with existing key (id_medico, tsrange(fecha_inicial, fecha_final))=(1, ["2021-04-22 08:00:00","2021-04-22 10:00:00")).