Re: Range Types: empty ranges

On 2/11/2011 1:50 PM, Kevin Grittner wrote:
> 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)'.

Does ['15:15:00','15:15:00') make any more sense? Doesn't this 
essentially mean
    >= '15:15:00' && < '15:15:00'

which again doesn't include a single point on the time line?


Jan

-- 
Anyone who trades liberty for security deserves neither
liberty nor security. -- Benjamin Franklin