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 a border condition, mktime() fails and would populate invalid data into the database. Most other *NIX's seem to automatically account for this and automatically adjust the value when it gets passed to mktime(&tm). Should FreeBSD 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. ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
