RTFM.
You have: tempK(1)
You want: tempC
-272.15
--
greg
---------------------------(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
