On Sat, Dec 26, 2015 at 23:03:30 +1100, Kevin Waterson <kevin.waterson@xxxxxxxxx> 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
-- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
