On 2/11/2011 1:50 PM, Kevin Grittner wrote:
Josh Berkus<j...@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
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers