Question about Postgresql time fields(possible bug) - Mailing list pgsql-hackers

From Tony Caduto
Subject Question about Postgresql time fields(possible bug)
Date
Msg-id 43C3D4E3.9040708@amsoftwaredesign.com
Whole thread Raw
Responses Re: Question about Postgresql time fields(possible bug)
List pgsql-hackers
Hi,
I just noticed today that Postgresql accepts a value of 24:00:00, this 
is for sure not correct as there is no such thing as 24:00:00

PG Admin III will display this value just fine which is also incorrect,  
PG Lightning Admin catches it as a invalid time, but shouldn't there be 
some validation of times and dates at the server level?  

There are people who are using PG Admin III and they don't even know 
they have bogus dates and times in their databases.


Thanks,

Tony


pgsql-hackers by date:

Previous
From: Joe Conway
Date:
Subject: Re: current_setting returns 'unset'
Next
From: Bruce Momjian
Date:
Subject: Re: Question about Postgresql time fields(possible bug)