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 i
"EXT-Rothermel, Peter M" 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 getting it to
work there.
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 explic
On Mon, Aug 27, 2012 at 11:46 AM, EXT-Rothermel, Peter M
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 into the same table tha