I cannot seem to find a field type in postgres that is equivalent to h:mm without enforcing a 24 hour day limit. This seems to preclude pg from use - am I correct?
You want to use "interval" data type and then do some formatting on the output to get 123 hours 30 minutes.
See: http://www.postgresql.org/docs/7.4/interactive/datatype-datetime.html
-- Michal Taborsky http://www.taborsky.cz
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
