Question about Postgresql time fields(possible bug)

Поиск
Список
Период
Сортировка
От Tony Caduto
Тема Question about Postgresql time fields(possible bug)
Дата
Msg-id 43C3D4E3.9040708@amsoftwaredesign.com
обсуждение исходный текст
Ответы Re: Question about Postgresql time fields(possible bug)  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Joe Conway
Дата:
Сообщение: Re: current_setting returns 'unset'
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Question about Postgresql time fields(possible bug)