Stumbled upon a time bug...

Is PostgreSQL broken? Or is it FreeBSD?

--

http://www.freebsd.org/cgi/query-pr.cgi?pr=ports/36954

PostgreSQL does not currently check the results of mktime().  On aborder condition, mktime() fails and would populate
invaliddatainto the database.
 
Most other *NIX's seem to automatically account for this andautomatically adjust the value when it gets passed to
mktime(&tm).ShouldFreeBSD have it's mktime() in libc updated?
 

CREATE TABEL tt ( tt TIMESTAMP );INSERT INTO tt VALUES ('2002-4-7 2:0:0.0');

--
Rod Taylor

Your eyes are weary from staring at the CRT. You feel sleepy. Notice
how restful it is to watch the cursor blink. Close your eyes. The
opinions stated above are yours. You cannot imagine why you ever felt
otherwise.