Re: [GENERAL] Overlapping time ranges constraints in 8.4

2012-08-28 Thread Merlin Moncure
On Mon, Aug 27, 2012 at 11:46 AM, EXT-Rothermel, Peter M peter.m.rother...@boeing.com wrote: I thought that this was going to be tricky. Perhaps I could use rules to populate a shadow table that is like a INNER JOIN of the two tables. This would consolidate the Boolean on the separate table

Re: [GENERAL] Overlapping time ranges constraints in 8.4

2012-08-27 Thread EXT-Rothermel, Peter M
I thought that this was going to be tricky. Perhaps I could use rules to populate a shadow table that is like a INNER JOIN of the two tables. This would consolidate the Boolean on the separate table into the same table that holds the time ranges. In version 8.4 I would still need to use

[GENERAL] Overlapping time ranges constraints in 8.4

2012-08-24 Thread EXT-Rothermel, Peter M
I have a temporal data question that may be much easier to handle in version 9.x but I am stuck on version 8.4. One table has a time range that is implemented as start_time and end_time columns of type TIMESTAMP with Timezone. A second table has information that is needed to determine if there

Re: [GENERAL] Overlapping time ranges constraints in 8.4

2012-08-24 Thread Kevin Grittner
EXT-Rothermel, Peter M peter.m.rother...@boeing.com wrote: I have a temporal data question that may be much easier to handle in version 9.x but I am stuck on version 8.4. That is unfortunate. Getting this to work correctly in 8.4 will probably be a lot more work than upgrading to 9.1 and