Re: roundoff problem in time datatype - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: roundoff problem in time datatype
Date
Msg-id 200510131419.01729.josh@agliodbs.com
Whole thread Raw
In response to Re: roundoff problem in time datatype  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: roundoff problem in time datatype
List pgsql-hackers
Tom,

> I think my preference is to allow '24:00:00' (but not anything larger)
> as a valid input value of the time datatypes.  This for two reasons:
>     * existing dump files may contain such values
>     * it's consistent with allowing, eg, '12:13:60', which we
>       allow even though it's certainly not a valid leap second.

It's also consistent with how several other RDBMSes do things (SQL Server, 
MySQL), and several programming languages.

-- 
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: roundoff problem in time datatype
Next
From: "Kevin Grittner"
Date:
Subject: Re: A costing analysis tool