On 1/30/20 9:03 AM, Achilleas Mantzios wrote:
Um, that makes my head hurt:) Questions:
1) Are the basic complete budgets and the sub-budgets and super
budgets existing in the same table?
2) Depending on answer to 1, to prevent overlap could you not use a
form of the example here?:
https://www.postgresql.org/docs/12/rangetypes.html#RANGETYPES-CONSTRAINT
CREATE TABLE reservation (
during tsrange,
EXCLUDE USING GIST (during WITH &&)
);
same table.
overlap is allowed but only when it is complete containment, which is
the whole point of this thread.
I finally got it. Unfortunately that does not mean I have solution.
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
