This is really not a problem, may be in other circumstances... This output has been obtained from a PostgreSQL 7.3.4
=== testdb=# select to_timestamp('23:20:30.123456', 'HH24:MI:SS.US')::time; to_timestamp ----------------- 23:20:30.123459 (1 row)
testdb=# select to_timestamp('23:20:30', 'HH24:MI:SS.US')::time; to_timestamp -------------- 23:20:30 (1 row)
testdb=# select to_timestamp('23:20:30', 'HH24:MI:SS.US')::time; to_timestamp ----------------- 23:20:30.123459 (1 row) ===
Bye!
Nhan NGO DINH
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match