On Sat, Dec 26, 2015 at 23:03:30 +1100,
Kevin Waterson <kevin.waterson@gmail.com> wrote:
>Thanks, as I am new to postgres, I was unaware of this function.
>To go with this, I guess I will need a table with which to store intervals,
>start and end dates?
There is are built in range types that might be more efficiebt for
indexing rather than using separate start and stop times. See:
http://www.postgresql.org/docs/9.5/static/rangetypes.html#RANGETYPES-BUILTIN