-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Benjamin Smith wrote:
> Given the tables defined below, what's the easiest way to check for schedule
> conflicts?
Assuming you don't count more than once things with the same id, start, and
finish:
SELECT COUNT(DISTINCT (s1.event_id||s1.start||s1.
Ragnar Hafstað wrote:
On Sat, 2005-03-12 at 00:13 -0800, Benjamin Smith wrote:
Given the tables defined below, what's the easiest way to check for schedule
conflicts?
So far, the only way I've come up with is to create a huge, multi-dimensional
array in PHP, with a data element for every minute
On Sat, 2005-03-12 at 00:13 -0800, Benjamin Smith wrote:
> Given the tables defined below, what's the easiest way to check for schedule
> conflicts?
>
> So far, the only way I've come up with is to create a huge, multi-dimensional
> array in PHP, with a data element for every minute of all time
Given the tables defined below, what's the easiest way to check for schedule
conflicts?
So far, the only way I've come up with is to create a huge, multi-dimensional
array in PHP, with a data element for every minute of all time taken up by
all events, and then check for any of these minutes t
