Re: Exclusion constraint issue
От
Eric McKeeth
Тема
Re: Exclusion constraint issue
Дата
Msg-id
AANLkTimZj+Hp8oZmG5WHOOWhtB-YoRE68fi+8Lhe4HyD@mail.gmail.com
Ответ на
Re: Exclusion constraint issue (Jeff Davis)
Список
Дерево обсуждения
Exclusion constraint issue Eric McKeeth <eldin00@gmail.com>
Re: Exclusion constraint issue Tom Lane <tgl@sss.pgh.pa.us>
Re: Exclusion constraint issue David Fetter <david@fetter.org>
Re: Exclusion constraint issue Tom Lane <tgl@sss.pgh.pa.us>
Re: Exclusion constraint issue David Fetter <david@fetter.org>
Re: Exclusion constraint issue Eric McKeeth <eldin00@gmail.com>
Re: Exclusion constraint issue Jeff Davis <pgsql@j-davis.com>
Re: Exclusion constraint issue Eric McKeeth <eldin00@gmail.com>
On Tue, Sep 28, 2010 at 4:07 PM, Jeff Davis <pgsql@j-davis.com> wrote:
My problem wasn't with getting the period type to represent overlaps with the correct inclusivity/exclusivity, but in getting it to work with my exclusion constraint. Can you show an example of how I could get that working perhaps?
On Tue, 2010-09-28 at 12:18 -0600, Eric McKeeth wrote:The period type supports different inclusivity/exclusivity combinations.
> This is ugly, but it does seem to enforce the constraint I need, of
> non-overlapping dates where sharing an endpoint is not considered an
> overlap.
So, the period:
'[2009-01-02, 2009-01-03)'
Does not overlap with:
'[2009-01-03, 2009-01-04)'
Because "[" or "]" means "inclusive" and "(" or ")" means "exclusive".
My problem wasn't with getting the period type to represent overlaps with the correct inclusivity/exclusivity, but in getting it to work with my exclusion constraint. Can you show an example of how I could get that working perhaps?
For further discussion, you can join the temporal-general@pgfoundry.org
mailing list (sign up at
http://pgfoundry.org/mailman/listinfo/temporal-general ). If this still
does not solve your use case, I'd like to see if it can be modified to
do so.
Regards,
Jeff Davis
I've subscribed to the temporal-general list, so we can move this discussion there if that's more appropriate.
Thanks,
Eric
В списке pgsql-general по дате отправления
От: Dr. Peter Voigt
Дата:
