As per my last post, I will be using a variable time for the day-to-day boundary, versus the traditional 12pm.
What I want to be able to do upon insert of a record with a pair of times is to determine if the day to day boundary is between the times that are in the record, and reject the record if that is true.
For example, if the system wide constant for the day-to-day boundary were 4AM local time, and I submitted a record like so:
INSERT INTO my_table(start_time, end_time) VALUES( '12:00'::TIME, '14:30'::TIME );
that should succeed. However:
INSERT INTO my_table(start_time, end_time) VALUES( '12:00'::TIME, '5:00'::TIME );
should fail. Any ideas wold be most appreciated.
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
