On Fri, Feb 11, 2011 at 1:50 PM, Kevin Grittner <[email protected]> wrote: > Josh Berkus <[email protected]> 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)'.
How would that actually work? I kind of agree with Josh: I'd be inclined to make the type input function boot such constructs at the door. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
