Re: Range Types: empty ranges - Mailing list pgsql-hackers

From Kevin Grittner
Subject Re: Range Types: empty ranges
Date
Msg-id 4D5530AA020000250003A878@gw.wicourts.gov
Whole thread Raw
In response to Re: Range Types: empty ranges  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Range Types: empty ranges  (Robert Haas <robertmhaas@gmail.com>)
Re: Range Types: empty ranges  (Jan Wieck <JanWieck@Yahoo.com>)
List pgsql-hackers
Josh Berkus <josh@agliodbs.com> wrote:
> if I, in one of my applications, accidentally defined something
> as having the range '('15:15:00','15:15:00')', I would *want* the
> database to through an error and not accept it.
I can agree with that, but I think that range '[15:15:00,15:15:00)'
should be valid as a zero-length range between, for example,
'[15:00:00,15:15:00)' and '[15:15:00,15:30:00)'.
-Kevin


pgsql-hackers by date:

Previous
From: Kääriäinen Anssi
Date:
Subject: Re: ALTER EXTENSION UPGRADE, v3
Next
From: Robert Haas
Date:
Subject: Re: Range Types: empty ranges